Category and Sub-category in rows in Pivot Table and sum values based on criteria in another column

[HansrajR]

Hi. I am working with a table and I need to arrange the row by location and sub-categories in the Pivot table.

In the columns, I need to sum values based on criteria in another column.

And in the end produce a comparison chart original/revised/final for each location.

Kindly find attached the Table, the pivot table arrangement and pivot chart I am seeking (done manually).

Can someone help me out.

 

[Chihiro]

I'd recommend restructuring your data table.

Instead of having multiple column for same data category, it should be in single column with multiple rows.
Ex: Area; Stock Type; Stock Count; Stock Quality.

This will make your analysis and pivot table much easier to set up. You can use Power Query (Get & Transform) to transform your data.