Learn Excel- Max(minus)Min in a Pivot Table: #1390

Name: Learn Excel- Max(minus)Min in a Pivot Table: #1390
Uploaded: 2011-04-25T14:31:14+00:00
Duration: 5 min 21 s
Channel: Bill Jelen
Description: 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.

Bill Jelen

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.

Category

Comments

Recommended