I forgot to say that I use LO 4.0.3.3
Regards,
Jorge Rodríguez
----- Mensaje original -----
De: "RODRIGUEZ FONSECA JORGE ALBERTO" <jrodriguez17@cpcecr.com>
Para: "LibreO - Users Global" <users@global.libreoffice.org>
Enviados: Domingo, 23 de Junio 2013 12:08:06
Asunto: It would be a bug
Hi all:
I have this charter No 1:
Code Sells Office
A 12 Here
S 13 Ala
S 3 Punta
D 5 Ala
A 4 Here
Then I use Pivot Table to get this other chart No. 2 by office from chart No. 1:
Oficina Ventas
Ala 18
Here 16
Punta 3
Total Resultado 37
I've used VLookUp function to get data from chart No 2 to this other chart:
Function: =BUSCARV(A3;'Tabla dinámica_Hoja2_1'.$A$11:$B$15;2)
Show Should Show
Office Sells Sells
Ala 18 18
Punta 3 3
Here 16 16
Cart 18 0
Lim 16 0
As you can see, the chart is order by office but I got 18 and 16 in "Cart" and "Lim" but It should
show 0 in both. The LO program get datas from "Ala" and "Here" for "Cart" and "Lim".
What happens ?
Regards,
Jorge Rodríguez
--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Context
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.