Q: Creating a Stacked Pareto in SSRS 2016 I work in a manufacturing environment.  We record defects (scrap and rework) on parts for 9 different reasons (eg Weld Fault).  I need to chart this for a dashboard in SSRS.
In SSRS, I am pulling the data out into a stacked bar chart so I can see total defects per defect type (and it's split by Scrap / Rework) , and this works great, however I want it to appear as a Stacked Pareto format (so, most common on the left, and reduces down to the right)
I'm relatively new to SSRS so this is a learning curve.  I'm guessing I need to do something with the Running Value - I've looked at using this to sort by, but according to the error received I cannot sort by RunningValue.
Does anyone have any suggestions as to how I could create a stacked Pareto?

A: Assuming you already have a stacked barchart, but it is not sorted largest to smallest.
All you should need to do is right mouse click on your category group, then click on the sorting tab then enter into the Expression something like 
=Count(Fields!Type.Value)
or
=Sum(Fields!Items.Value)
Depending on whether your bars sum a field or are counts of records in your dataset. It should be the same as the series calculation, ie what highlighted below

To make largest to smallest you will need to change the sort order to Z to A.
