Percentage point in Pivot Tables
 

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

Percentage point in Pivot Tables
 

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

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