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

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 valu=
es
> for the current year. Both are shown as % af column. Now, I would als=E5 =
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 differ=
ence
> in percentage point?
>=20
> Can anyone give me a hint here?
>=20
> Thanks.
>=20
> /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
>
>