Add a column outside pivot table and...
 

Hi!

I´ve searched the web for my following question and it seems to be
unanswered... I would like to work with my pivot table to make next
years budget.. I have a pivot table that a recieve through SQL server
where I´ve got this years numbers...And I would like to add a kolumn
(outside the pivot table) where I set next years budget so this kolumn
_must_ refer to the pivot table so that this numbers won´t change if I
change the layout of my pivot table....possible?

Hope that you know what I mean...It´s hard to explain this in english
though I´m not a english spoken person...Please give me feeback if the
above question is incomprehensive....


--
mrright
------------------------------------------------------------------------
mrright's Profile: http://www.excelforum.com/member.php...o&userid=28236
View this thread: http://www.excelforum.com/showthread...hreadid=477895

Add a column outside pivot table and...
 

You could make a static table with the year numbers and use lookup functions
to find the past values on the pivoted data.

"mrright" escreveu:


Hi!

I´ve searched the web for my following question and it seems to be
unanswered... I would like to work with my pivot table to make next
years budget.. I have a pivot table that a recieve through SQL server
where I´ve got this years numbers...And I would like to add a kolumn
(outside the pivot table) where I set next years budget so this kolumn
_must_ refer to the pivot table so that this numbers won´t change if I
change the layout of my pivot table....possible?

Hope that you know what I mean...It´s hard to explain this in english
though I´m not a english spoken person...Please give me feeback if the
above question is incomprehensive....


--
mrright
------------------------------------------------------------------------
mrright's Profile: http://www.excelforum.com/member.php...o&userid=28236
View this thread: http://www.excelforum.com/showthread...hreadid=477895