I have a pareto chart by dimension called "Reason Detail". I have 2 expressions - one for the bar chart which is "sum(qty)"and other for line chart which is the cumulative % "Rangesum(above(sum(qty),0,RowNo())/sum(total qty)"
I need to show bars until 80% cumulative % with their respective dimension values and then a sharp spike from 80% to 100% with just one bar named as "Others". In other words my cumulative line should show bars <= 80% and then one bar for 100% with a spike from 80% to 100%. How do I accomplish this? Any help is much appreciated.
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
.png "Former Employee"){kind=icon}
