ExcelBanter - PivotTable data...

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - PivotTable data... (https://www.excelbanter.com/excel-discussion-misc-queries/11602-pivottable-data.html)

SkoolGirl

PivotTable data...

How do I use more than one Summary function for a PivotTable data field?

Debra Dalgleish

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

All times are GMT +1. The time now is 03:45 AM.