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

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

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