Formula in Raw Data for pivot

[sice]

Hey guys/gals,

I have a question about pivots tables and formuals in the raw data. What I am trying to do is an absolute formula within the raw data, so that I do not have to do it on each individual tab and just have it in the raw data to add into the pivot.

Example: in the raw data I have columns with orders and forecast. I do an absolute formula in that raw data to get a number (lets say the number ended up being 9). Now when I create a pivot and add product, order, forecast and absolute formula it shows something much different (a higher number 35). Any idea how I can just get the number that is showing in the raw data without it creating a new number??

Overview: The formula in the raw data is showing differently in the pivot.

 

[cyrilbrd]

Hi,
in order to get sound advise would you consider posting a sample of your raw data.
a sample of what you would like to see in the pivot
and the formula that you are presently using.

link.

link.