I got this request from my manager to produce a comprehensive visualized analysis similar to the attached excel.
I have three dimensions:
Mappings are provided for the three dimensions. The total cost for each part varies based on the product as well as the factory.
The deliverable needs to be in a pivot table as in the 'Desired Pivot Table Output' tab though it may not look identical. e.g. I did not put the A a1 AA combination.
Thanks a ton!