Add a column outside pivot table and...

[mrright]

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....

[Fred]

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
>
>