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)

Pivot Table Import Link to Numerical Values
 

Try using A48&""

Wynn wrote:
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)


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Pivot Table Import Link to Numerical Values
 

brilliant! thanks.

"Debra Dalgleish" wrote:

Try using A48&""

Wynn wrote:
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)


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Pivot Table Import Link to Numerical Values
 

You're welcome!

Wynn wrote:
brilliant! thanks.

"Debra Dalgleish" wrote:


Try using A48&""

Wynn wrote:

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)


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html