Add a column outside pivot table and...

M

mrright

Hi!

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

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

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