multiple subtotals in pivot table

C

ChrisC

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
 
J

Jim Thomlinson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

can i add subtotals to subtotals in a pivot table? 1
Pivot table subtotals 2
how do I show grand totals for subtotals 0
Using Subtotals tool to average multiple rows of non-continuous data based on ID # 0
2007 Excel Table and Pivot Table Formatting 0
Filtering within Pivot Table 1
Doughnut Chart linked with the slicer in the pivot table 0
Pivot Table Count 1

Top