| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tabke - Average Total
Is it possible to have an average at the bottom of a pivot table rather than
the grand total? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Tabke - Average Total
If you add a data field, and set it to show the average, the column
total for that field would also be an average. To change the field settings, right-click on the Data field button, and choose Field Settings Under Summarize, select Average, and click OK Welly wrote: Is it possible to have an average at the bottom of a pivot table rather than the grand total? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pivot total | Excel Discussion (Misc queries) | |||
| Pivot Chart which shows average line with below and above figures | Charts and Charting in Excel | |||
| Sorting Pivot Table by Grand Total | Excel Discussion (Misc queries) | |||
| Sorting Pivot Table by Grand Total | Excel Discussion (Misc queries) | |||
| Pivot Tables- Total the Subtotals? | Excel Worksheet Functions | |||
Linear Mode
