| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtotals in a Pivot Table | Excel Worksheet Functions | |||
| can i add subtotals to subtotals in a pivot table? | Excel Discussion (Misc queries) | |||
| pivot table subtotals | Excel Worksheet Functions | |||
| Pivot Table SubTotals | Excel Discussion (Misc queries) | |||
| subtotals in a pivot table | Excel Worksheet Functions | |||
Linear Mode
