Learn Excel- Max(minus)Min in a Pivot Table: #1390
2011-04-25 2 Dailymotion
Kelly wants to display a Range in a Pivot Table. Unfortunately, Calculated Fields in a Pivot Table look at each individual row, so the MAX(B2)-MIN(B2) will always be zero. PowerPivot and the DAX Measure come to the rescue in Episode #1390.
