Percentage point in Pivot Tables
Hi
Um, please explain? My problem is, that a calculated field subtracts the
values, not the respective percentages. This gives me the difference in
absolute terms, not percentage points. % af column does not give me
percentage point but rather the relative difference compared to the total.
Maybe I should just do the calculations on the database that feeds the
spreadsheet instead.
/Sune
"Mr.Cools" wrote:
Its easy.
Click the arrow next to the pivot table toolbar.Select "FORMULAS" and
click"CALCULATED FIELD".The rest could be done with Microsoft Help
Sune Fibaek wrote:
Hi
A quick questions about pivot tables:
I have two data fields. One vith values from last year, and one with values
for the current year. Both are shown as % af column. Now, I would alså like
to show the difference in percentage points. Is it possible to make a
calculated field that subtract one value from another and show the difference
in percentage point?
Can anyone give me a hint here?
Thanks.
/Sune
|