Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index


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.