Hosted by Dailymotion. For legal issues report at the Copyright Center, report us on DMC, or use the Instant Removal tool.
Learn Excel- Max(minus)Min in a Pivot Table: #1390
B
Bill Jelen
7 Views • Apr 25, 2011
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.
Keywords & Tags
More from User
02:34
MrExcel's Learn Excel #976 - Default Comment
Bill Jelen
03:19
Learn Excel 2010 - "Date Next to a Yes" #1474
Bill Jelen
07:51
Dueling Excel - "Rank Ties by Weight" #1473
Bill Jelen
03:39
Learn Excel 2010 – “Wrap Cells and Resize" #1472
Bill Jelen
02:08
Learn Excel 2010 - "Random with No Repeats" #1471
Bill Jelen
06:30
Learn Excel - "Copy Total to Weeks Macro": #1470
Bill Jelen
Related Videos
00:06
Download Excel 2016 Pivot Table Data Crunching (includes Content Update Program) (MrExcel Library)
Schorr8
02:58
Learn Excel from MrExcel - "Pivot to Range": #1456
Bill Jelen
00:23
About for Book Power Excel With MrExcel 2017: Master Pivot Tables, Subtotals, Visualizations,
nekmev
00:04
READ ONLINE Power Excel with MrExcel 2017 Edition Master Pivot Tables Subtotals Visualizations
Emildeluxe 3e
00:05
Read Excel 2016 Pivot Table Data Crunching (includes Content Update Program) (MrExcel Library)
Lewi01
03:29
Learn Excel from MrExcel Episode 913 - Pivot Rates II
Bill Jelen