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

April 25, 2011 at 2:41 pm

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 here and in Episode #1390, Bill shows us how its done!

"PowerPivot For The Data Analysit" by Bill Jelen…This blog episode is the video podcast companion to the book, “PowerPivot For The Data Analyst: Microsoft Excel 2010“, from Bill Jelen a.k.a. MrExcel.

For more Excel 2010 knowledge, check out “Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions.


Entry filed under: Excel 2010, Excel 2010 In Depth, Excel and PowerPivot, Learn Excel from MrExcel, MrExcel Podcast, MrExcel Products, New MrExcel Publication, Pivot Tables, PowerPivot, PowerPivot 2010. Tags: , , , , , , .

Dueling Excel – Add A Hyperlinked TOC: Podcast #1389 Learn Excel – The MrExcel Message Board: Podcast #1391

Learn Excel from MrExcel

Learn Excel Podcast Splash Screen

The Excel Beginners Book:

"Don't Fear The Spreadsheet" - by Tyler Nash, Bill Jelen, Tom Urtis and Kevin Jones

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 743 other followers

Live Lessons Excel 2010 DVD

"Live Lessons Excel 2010" DVD

RSS MrExcel Recent Articles

  • An error has occurred; the feed is probably down. Try again later.

Recent MrExcel Tweets

MrExcel Podcast Archive

%d bloggers like this: