Sort supplier by [Amount} with Descending
Then cal field.
if [Run_Sum] <=0.7 then "Top"
elseif [Run_Sum] <=0.9 then "Mid"
You can refer this post
Pareto_9.0.twbx 31.3 KB
i still cannot convert the calculated measure in a dimension
therefore i cannot use that value as a dimension to calculate metrics on or create weighted averages
I'm not 100% confident, but you need to put "Supplier" and "Included" in your detail always to keep this Pareto effective.
Means without these details, pareto cannot keep it's structures.
test pareto_rep_9.2.twbx 37.3 KB
Not sure i understand
Can you please help?
I have Tried potting 'included' and 'supplier' under 'Marks' but I still cannot move Pareto from measure to dimensions
I am not sure what you are referring to with 'details'
Please any help is appreciated
Sent from my iPhone
Sorry for confusing you.
I'm afraid you can put that field into "Dimension".
But still can do something with that field as "Measure".
You can read through below post for detail.
Maybe I missed something.