I would appreciate some assistance on the following. I have a table (see attached example image).
I would like to apply a Donut Chart such that I am able to report on the percentage split between mining and plant cost.
We have quiet a substantial back-end of data and I want to avoid having to unpivot data in the query editor, Is there any alternative measure that can be created that will correctly apportion the cost for mining and plant?
Any help would be greatly appreciated