Power Pivot is an Excel built-in feature (for Excel 2013 and later) that allows you to significantly extend the capabilities of regular PivotTables. But, what if you need something different such as the median? That’s when Power Pivot comes into play. If you click on More Options…, you can select other functions such as Standard Deviation and CountNumbers. Just right-click inside of the PivotTable → Go to Summarize Values By → Select the summary function Change summary function in PivotTable If you’re a regular user of Excel PivotTables you might know you can change the summary function:
Yes, you read the title of this post correctly, you can calculate the median and lots of other functions in Excel PivotTables besides the regular options.
0 kommentar(er)
