I forgot to say that I use LO 4.0.3.3 Regards,
Jorge Rodríguez ----- Mensaje original ----- De: "RODRIGUEZ FONSECA JORGE ALBERTO" <jrodrigue...@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+unsubscr...@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