Hi community,
since I already found a lot of help in this forum, I guess this is a good place to ask the following question.

Situation:
I'm in charge of several product quality tracking statistics in my company. These are Excel files in which the colleagues enter each case and the details for customer related claims for each product. This would be, by example, the root cause of a problem, concatenated from main failure category, defect part and failure cause, and the costs this failure has created. I implemented a worksheet which acts as data base, and from this base several evaluations are generated. The important data set for this specific question is the section about failure causer and the associated costs. Example picture:
Data base.png

Request:
My boss now requested a new evaluation in which one can see the costs a specific problem has generated and a comparison of how much money could have been saved if an appropriate countermeasure would have been installed in early production. This needs to be generated from a Pivot Table, since new cost causers are added all the time, and the evaluation must be automated. This one I already created.

Problem:
The request also contains the requirement to pareto the evaluation, meaning that the output (graph) is sorted by most expensive failure category (Level1) and most expensive cost causer (Level2). He also wants that the total amount column is stacked from all cost types. Example picture:
Evaluation.png
And this is where I don't know how to implement it. From my understanding, this means I would need to have a 2-level, 3-dimensional stacked-clustered column chart, but I'm not sure if this is even possible.

Question:
I know that I need to add the other cost types to the Pivot Table for the stacking. I already found several tutorials on how to create a stacked-clustered column chart, but neither of them could cover the second level I need for the Pareto sorting, nor the need to stay in a Pivot Table based on the already existing data set/layout, which must not be changed (or I just didn't get them). This gets even more complicated because of all the coding I needed to do to run the special features in the background.

Tricky stuff, any advice regarding this issue is much appreciated.

Kind regards