Hi Arne

You can drag the field to the data area a number of times.
If the field is numeric, then you could drag it onto he data area 3
times.
On the Layout tab,
double click the first occurrence and select Count.
double click the second occurrence and select Sum
double click the third occurrence and select Average

On the PT, drag the Data button across and drop it in Total, and you
will have the 3 values side by side



--
Regards

Roger Govier


"Arne Hegefors" wrote in
message ...
Hi! I have a pivot table. In the actual table the data is shown as
number of
occurences. Also the automatically created colmn and row "Total" shows
the
total sum of the number of occureneces. However I wnat to show number
of
occurences in the table and then the mean value at the end instead of
total.
but when i try to change this the data in the table also changes. is
there
any way to do this? thanks!