Stu Dapples
Active Member
- Joined
- Jan 12, 2009
- Messages
- 252
Hi,
I am recording the downtime of machines and putting into order of most - least downtime for each of the reasons recorded against the machine being monitored. This works fine when sorting the ivot table by the total downtime column.
I have been asked if I can add a cumulative percentage line to the pivot chart as this is the standard used for pareto analysis (80% of losses are attributed to 20% of reasons) I can obviously get a percentage of each reason code but cant figure out how to do a cumulative percentage....
II can do it externally to the pivot table which works fine but when you return the data to the pivoot table, it gets sorted by the downtime column and obviously upsets the order of the cumulative count.
I hope that makes sense!!
BTW, Merry Christmas and a Happy, Peaceful and Prosperous New Year to you all!!
I am recording the downtime of machines and putting into order of most - least downtime for each of the reasons recorded against the machine being monitored. This works fine when sorting the ivot table by the total downtime column.
I have been asked if I can add a cumulative percentage line to the pivot chart as this is the standard used for pareto analysis (80% of losses are attributed to 20% of reasons) I can obviously get a percentage of each reason code but cant figure out how to do a cumulative percentage....
II can do it externally to the pivot table which works fine but when you return the data to the pivoot table, it gets sorted by the downtime column and obviously upsets the order of the cumulative count.
I hope that makes sense!!
BTW, Merry Christmas and a Happy, Peaceful and Prosperous New Year to you all!!
