Excel Workout 9 - Pivot Table 1

[Sujan_Chhetri]

PivotTable showing % of sales made by each Manufacturer in each year, relative to total sales of all manufacturers in that year:

Chart wrt to above PivotTable: (Got an idea from @homesh_agarwal):

PivotTable showing % of sales made by each Manufacturer in each year, relative to their overall sales:

Here’s my workout file: Challenge #9.xlsx (8.4 MB)