multiple subtotals in pivot table
 

Hi,

I would like to add multiple subtotals and grand totals to my pivot tables
and have been unsuccessful. For example, I currently can see subtotals by
year for certain data by sum but I would also like to see average and
standard deviation - three or more subtotals and grand totals at the same
time.

Chris

multiple subtotals in pivot table
 

Add more instances of your fields that you are summing and change the
aggregaion of the newly added fields. You are not limited to just one
instance in the data area.
--
HTH...

Jim Thomlinson


"ChrisC" wrote:

Hi,

I would like to add multiple subtotals and grand totals to my pivot tables
and have been unsuccessful. For example, I currently can see subtotals by
year for certain data by sum but I would also like to see average and
standard deviation - three or more subtotals and grand totals at the same
time.

Chris