| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
PivotTable data...
How do I use more than one Summary function for a PivotTable data field?
|
|
#2
|
|||
|
|||
|
In the Pivot Wizard, add another copy of the field to the data area
Double-click on the new field, and under 'Summarize by', choose one of the functions. SkoolGirl wrote: How do I use more than one Summary function for a PivotTable data field? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with data not getting plotted | Excel Discussion (Misc queries) | |||
| Help with data not getting plotted | Charts and Charting in Excel | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| Charting data ranges that change | Charts and Charting in Excel | |||
| How to lock a worksheet and enable the PivotTable refresh data opt | Excel Worksheet Functions | |||
Hybrid Mode
