Pivot2.png

Pivot1.png

Pivot-Sum-of-Max-r1.xlsx

<div>
@Carl - additional issues, did this solution not work for you, or are you ready to close this out?<br />
<br />
dave
</div>


@Carl - additional issues, did this solution not work for you, or are you ready to close this out?

dave

<div>
Pointed me in the right direction
</div>


<div>
<div class="content wysiwyg-content">
If i have a pivot table that has a column with max values can i change the total to be the sum of the values and not the max?<br />
<br />
i.e. I have a column showing the max values:<br />
<br />
1000<br />
2000<br />
500<br />
250<br />
1750<br />
<br />
The total is currently showing 2000 (the max), I need it to show 5500 (the sum)<br />
<br />
Any ideas?
</div>
</div>


If i have a pivot table that has a column with max values can i change the total to be the sum of the values and not the max?

i.e. I have a column showing the max values:

1000
2000
500
250
1750

The total is currently showing 2000 (the max), I need it to show 5500 (the sum)

Any ideas?

Pivot Table Total as sum When field is Max

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.