Pivot Table Import Link to Numerical Values
I am using the import values from a pivot table function and I can't seem to
reference cells that have numerical years listed.
I want to use the reference to cell A48 but it doesn't work. It does work
when cell A48 contains text. (i'm working on a spanish version but i figure
the answer is universal)
What I want:
=+IMPORTARDATOSDINAMICOS("Suma de tot_oferta_inicial";'Dinamicas
entrega'!$B$8;"municipio";C48;A48;I48)-IMPORTARDATOSDINAMICOS("Suma de
tot_vendidas";'Dinamicas entrega'!$B$8;"municipio";C48;A48;I48)
What I have to do:
=+IMPORTARDATOSDINAMICOS("Suma de tot_oferta_inicial";'Dinamicas
entrega'!$B$8;"municipio";C48;"2006";I48)-IMPORTARDATOSDINAMICOS("Suma de
tot_vendidas";'Dinamicas entrega'!$B$8;"municipio";C48;"2006";I48)
|