Calculate Median in PivotTable

Pivot Tables are one of the greatest analytical tools in Excel for it's capability to slice and dice data. It can summarize data by sum, average and even standard deviation. But the one of the basic statistical measures is the median and unfortunately that is missing from the pivot table options. Fortunately you can include that option in and it just involves creating the pivot table and adding it into the data model to write a simple DAX measure. See how it works by watching this short video.

Ranking within Groups with Power Pivot

Ranking items is fairly easy to do in Excel whether you're doing it for a table or in a pivot table, but when it comes to showing ranking within groups, you might need to use some combination of functions. This videos show how it can be done with DAX functions (like RANKX and CALCULATE) in Power Pivot. It's actually not too complicated and once you get the hang of using it, the results are pretty neat!

Customize Pivot Table Default Layout Style

When you create a PivotTable it defaults to certain views and if you create Pivot Tables often you probably adjust it a lot. Maybe you don't like the compact Pivot layout with it's nested view and prefer Tabular with repeated row values. Once the Pivot table is created you can manually change it by going into Options and changing it for each feature which this video will cover. That works if you don't create Pivot Tables that much, but if you do create them often and don't want to always click and select everytime just make those views the default. When you go into the Backstage view in Excel, just adjust the default settings and they will apply every time you create a Pivot and become your new Pivot Table defaults. Check out the video to learn how to customize this now.