I created a Pivot table in Excel. The field setting for the data's values is set to Max.
I would like the pivot table subtotal to Sum those Max values, but when I change the subtotal field setting to Sum it adds all of the underlying data that's part of that set. Here's what the table looks like:
Capture.PNG
Here's a sort of text description, in case you can't see the picture.
Row Labels Max of Count
A 22
Name 1 5
Name 4 9
B 21
Name 1 7
Name 5 8
As you can see, the subtotals (in bold) are totaling all of the underlying data for that subtotal group. Is it possible to have the pivot table only subtotal the entries shown? So the subtotal for A would be 14 and the subtotal for B would be 15.
Is this possible? Any advice?
Bookmarks