I am trying to create the pareto chart of "Total % of profit" and "total profit" by product sub-category. I came across the following issues and was wondering if there is another approach.

1. In a report, you can create a "% of Total" calc for measure. However, how do you make it cumulative? Which is the Pareto curve in orange (below graph shows).
2. When I have a report with two measures - say "Total Profit" and "% of Total of Profit", I am unable to sort by any of the measures. I can only sort the x-axis category measures i.e. product sub-category. Is this a bug or by design? It would be useful to sort by one measure - like the graph below.
3. Is it possible to create an aggregate measure to calculate "% of Total" and then use the cumulative calc in the report? If yes, can you show us the formula.

Regards

Sunil