Forum Discussion
Cumulative Total
I believe I have found the reason I was getting the error. I only provided information that I was using after a filter and not the entire data source table. Since this is first time I am posting, I have not yet figured out how to attach a file, so I will provide a sample of the excel file data source.
*Note: I have provided 2 Users for a 3-Month sample, but I have a total 28 Users with more to be added in the future*
| Unique Identifier | User | Supervisor | Month | Errors | Error Volume | Efficiency Score | Quarter |
| T.B.-January | T.B. | Supervisor #1 | January | Timeliness | 2 | 60% | Q1 |
| T.B.-January | T.B. | Supervisor #1 | January | Appropriate Activity Code | 0 | 100% | Q1 |
| T.B.-January | T.B. | Supervisor #1 | January | Appropriate Notes | 1 | 80% | Q1 |
| T.B.-January | T.B. | Supervisor #1 | January | Appropriate Escalation | 1 | 80% | Q1 |
| T.B.-January | T.B. | Supervisor #1 | January | Resolution | 0 | 100% | Q1 |
| T.B.-February | T.B. | Supervisor #1 | February | Timeliness | 2 | 60% | Q1 |
| T.B.-February | T.B. | Supervisor #1 | February | Appropriate Activity Code | 2 | 60% | Q1 |
| T.B.-February | T.B. | Supervisor #1 | February | Appropriate Notes | 3 | 40% | Q1 |
| T.B.-February | T.B. | Supervisor #1 | February | Appropriate Escalation | 0 | 100% | Q1 |
| T.B.-February | T.B. | Supervisor #1 | February | Resolution | 1 | 80% | Q1 |
| T.B.-March | T.B. | Supervisor #1 | March | Timeliness | 3 | 40% | Q1 |
| T.B.-March | T.B. | Supervisor #1 | March | Appropriate Activity Code | 0 | 100% | Q1 |
| T.B.-March | T.B. | Supervisor #1 | March | Appropriate Notes | 2 | 60% | Q1 |
| T.B.-March | T.B. | Supervisor #1 | March | Appropriate Escalation | 0 | 100% | Q1 |
| T.B.-March | T.B. | Supervisor #1 | March | Resolution | 1 | 80% | Q1 |
| L.B.-January | L.B. | Supervisor #2 | January | Timeliness | 1 | 80% | Q1 |
| L.B.-January | L.B. | Supervisor #2 | January | Appropriate Activity Code | 0 | 100% | Q1 |
| L.B.-January | L.B. | Supervisor #2 | January | Appropriate Notes | 2 | 60% | Q1 |
| L.B.-January | L.B. | Supervisor #2 | January | Appropriate Escalation | 1 | 80% | Q1 |
| L.B.-January | L.B. | Supervisor #2 | January | Resolution | 0 | 100% | Q1 |
| L.B.-February | L.B. | Supervisor #2 | February | Timeliness | 3 | 40% | Q1 |
| L.B.-February | L.B. | Supervisor #2 | February | Appropriate Activity Code | 0 | 100% | Q1 |
| L.B.-February | L.B. | Supervisor #2 | February | Appropriate Notes | 0 | 100% | Q1 |
| L.B.-February | L.B. | Supervisor #2 | February | Appropriate Escalation | 0 | 100% | Q1 |
| L.B.-February | L.B. | Supervisor #2 | February | Resolution | 1 | 80% | Q1 |
| L.B.-March | L.B. | Supervisor #2 | March | Timeliness | 0 | 100% | Q1 |
| L.B.-March | L.B. | Supervisor #2 | March | Appropriate Activity Code | 1 | 80% | Q1 |
| L.B.-March | L.B. | Supervisor #2 | March | Appropriate Notes | 3 | 40% | Q1 |
| L.B.-March | L.B. | Supervisor #2 | March | Appropriate Escalation | 2 | 60% | Q1 |
| L.B.-March | L.B. | Supervisor #2 | March | Resolution | 0 | 100% | Q1 |
This chart shows what I expect the table and therefore Pareto Chart to look like.
Error E.V. .T. Chart %
| Timeliness | 11 | 11 | 34.38% |
| Appropriate Notes | 11 | 22 | 68.75% |
| Appropriate Escalation | 4 | 26 | 81.25% |
| Appropriate Activity Code | 3 | 29 | 90.63% |
| Resolution | 3 | 32 | 100.00% |
Hi mol_ad ,
You can try formula like below:
Running Total =
VAR CurrentError =
SELECTEDVALUE ( 'YourTableName'[Errors] )
RETURN
CALCULATE (
SUM(YourTableName[Error Volume]),
FILTER (
ALLSELECTED ( 'YourTableName'[Errors] ),
'YourTableName'[Errors] <= CurrentError
)
)ratio: =
DIVIDE (
[Running total],
CALCULATE ( SUM ( 'YourTableName'[Error Volume] ), ALL ( 'YourTableName' ) )
)
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you! However, I am attempting to create a Pareto Chart with the data and therefore will be sorting the Errors based on Error Volume from largest to smallest and not alphabetically.
Below is what I am looking to accomplish.
Error E.V. R.T. Chart %
Timeliness 11 11 34.38% Appropriate Notes 11 22 68.75% Appropriate Escalation 4 26 81.25% Appropriate Activity Code 3 29 90.63% Resolution 3 32 100.00% Here is the resulting table I get when sorting the Errors by Error Volume:
Errors Error Volume Running Total Appropriate Notes 11 18 Timeliness 11 32 Appropriate Escalation 4 7 Appropriate Activity Code 3 3 Resolution 3 21 Total 32