Excel Pivot Table – Total of Minimums – 2588

Microsoft Excel Tutorial on Pivot Tables.
Illia K asks: “Hello, is it possible to sum min values column in grand total? If I choose sum in grand total it turn column in sum of values and I just need sum of min values. can you please help?”

In this video, I show how the Grand Total of a column of Minimums is normally the Minimum value in the column.

However, using a trick from Rob Collie and a Data Model Pivot Table with two DAX Measures, I manage to Sum the Minimums in the Grand Total.

Here are the 12 steps needed to make this work:
Steps:
1. Make into a Ctrl+T table
2. Name the data, such as BillData
3. Insert, Pivot Table, Data Model, Existing Sheet
4. Drag Sector to Rows
5. Right-click Table name, Add Measure
6. MinSales = MIN(BillData[Revenue])
7. Add to Pivot Table
8. Right-click Table name, Add Measure
9. MinSalesWithSumMins = SUMX(Values(BillData[Sectors],MinSales)
10. Add to Pivot Table
11. Check Total
12. Remove MinSales from Pivot Table

Table of Contents
(0:00) How to Sum the Mins in the Grand Total row of a pivot table?
(0:37) Ctrl+T Table and rename
(1:01) Pivot Table with Data Model
(1:32) Add MinSales measure
(2:24) Add MinSalesSumOfMins measure
(2:39) SUMX is an iterator
(3:27) Add MinSalesSumOfMins to Pivot Table and verify total
(3:42) Remove MinSales from PivotTable
(4:23) Outtake: Wrong answer if you put MIN() inside SUMX without creating MinSales.