Forum Discussion
peoplehelpme
Helper I
3 years agoHow to modify pareto chart
I want my pareto to be like this but my chart is like this can anyone help me please
grim07181208
3 years agoNew Member
Try these steps:
Ranking - RANKX(ALLSELECTED(Column), [Count])
Cumulative Count = CALCULATE([Count], TOPN([Ranking], All(Column]), [Count]))
Cumulative % = DIVIDE([Cumulative Count], CALCULATE([Count], ALL(Column])))