Download Files:
Start File: https://excelisfun.net/files/EMT1418Start.xlsx
Finished File: https://excelisfun.net/files/EMT1418Finished.xlsx
Entire page with all Excel Files for All Videos: https://excelisfun.net/
See how to use Standard PivotTables to rank profits and profits per unit for both All The Products and Products within Manufacturer:
1. (00:10) Introduction
2. (01:31) PivotTable #1 for Total Profit per Product and Ranking of Profits for each Product within Manufacturer. See the Show Values As Rank Feature.
3. (06:21) PivotTable #2 for Ranking of Profits for each Product
4. (07:40) Create Custom List so PivotTable will Sort Correctly
5. (09:10) PivotTable #3 for Unit Profit and rank for each Product within Manufacturer. See how to create a Calculated Field in a Standard PivotTable (NOT a DAX Formula)
6. (12:23) PivotTable #4 Ranking Product Profit
7. (14:08) Summary


Related Videos:
Excel Magic Trick 1417: Excel Functions Ranking For Unit & Total Profit for Products within Manufacturer
Excel Magic Trick 1418: PivotTables Ranking For Unit & Total Profit for Products within Manufacturer
Excel Magic Trick 1419: RANKX DAX Function & More: Ranking Profit for Products within Manufacturer
Excel Magic Trick 1420: Ranking in Power Query: Sort, Grouping, Indexes and Custom Columns