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: [email protected]
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
