|
Microsoft Excel - 'Summarise Values By' with Pivots
'Summarise Values By' lets you change what your PivotTable calculates, making it easy to look at the same data from different angles and 'Show Values As' allows you to quickly calculate percentages i.e. % of the Grand Total, and here's 3 good reasons why you should learn about them.
- Allows you to analyse the same data in different ways.
- Answer different questions i.e. Sum for total sales, Average for average order value, or Count for the number of orders, and
- Excel performs the calculation automatically, so there’s no need to create separate formulas in your worksheet.
Click here to learn more
|