Microsoft Excel - Show Values As (Extra Calculations for Pivot Tables)
Learn about a host of advanced calculations built-in to Excel Pivot Tables. Create ranks, month-over-month, running percentages, and much, much more.
File Download Link:
https://www.bcti.com//wp-content/YT_D...
00:00 Introduction
01:18 Changing the Base Aggregation
02:10 Adding Non-Standard Aggregations
02:44 Ranking Entries
04:18 Percentage of Sales
04:55 Hiding "Grand" Percentages Using Conditional Formatting
06:50 Resetting Percentages
09:25 Cumulative Totals
11:33 Cumulative Percentages
12:20 Differences From
14:39 Adding Icons from Conditional Formatting