Pivot Table Import Link to Numerical Values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
Try using A48&""
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)
Click to expand...
 
Back
Top