See how to use Standard PivotTables to rank profits and profits per unit for both All The Products and Products within Manufacturer:
(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