Excel - Median in Pivot Table - Podcast 2197

Microsoft Excel Tutorial: Alex from Houston asks: Can you do a Median in a Pivot Table The traditional answer is No! But thanks to the Data Model, you can create a Median Ctrl+T to make your data into a Table Insert, Pivot Table, Add this Data to the Data Model Right-click the Table name and choose New Measure The Measure will be =MEDIAN([Sales])