Excel Magic Trick 1418

PivotTables Ranking For Unit & Total Profit for Products within Manufacturer

DESCRIPTION

See how to use Standard PivotTables to rank profits and profits per unit for both All The Products and Products within Manufacturer:
(00:10) Introduction
(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.
(06:21) PivotTable #2 for Ranking of Profits for each Product
(07:40) Create Custom List so PivotTable will Sort Correctly
(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)
(12:23) PivotTable #4 Ranking Product Profit
(14:08) Summary

WORKBOOKS

Download “Excel Magic Trick 1416-1420” Excel-Magic-Trick-1416-1420.zip – Downloaded 78 times – 4 MB







Be the first to comment

Leave a Reply