Forum Discussion
ElliotP
10 years agoPost Prodigy
Cumulative Total
Hi, I'm at an absolute loss as to how to calculate a cumulative total. I've tried googling, reading the forums, following the documentation, decomposing the calculation, trying it as both a measu...
- 10 years ago
ElliotP Sorry about the original post. It was from my phone and had typos :smileywink:
Okay here is the formula for Running Total as a Calculated Column (prorerly formatted)
Running Total COLUMN = CALCULATE ( SUM ( 'All Web Site Data (2)'[UniquePageviews] ), ALL ( 'All Web Site Data (2)' ), 'All Web Site Data (2)'[Date] <= EARLIER ( 'All Web Site Data (2)'[Date] ) )And as you can see it works! :smileyhappy:
And here's the MEASURE formula
Running Total MEASURE = CALCULATE ( SUM ( 'All Web Site Data (2)'[UniquePageviews] ), FILTER ( ALL ( 'All Web Site Data (2)' ), 'All Web Site Data (2)'[Date] <= MAX ( 'All Web Site Data (2)'[Date] ) ) )Which also works...
Anonymous
4 years agoNot applicable
Hi,
wouuld you like to solve my issue . I triying to get the cumulative flag according to %age.
one person have 4 channel if there 3 chanel fill 80% then previous three should be come in flag like "top 80%" and 4th should be "rest")
Hi its my humble request please solve this query
| Name | Retailer | Channel | Val | Contri | NEED ANS LIKE |
| Achampet | R2 | C1 | 42 | 36% | Top 80% |
| Achampet | R1 | C2 | 30 | 26% | Top 80% |
| Achampet | R3 | C1 | 26 | 22% | Top 80% |
| Achampet | R4 | C2 | 19 | 16% | Rest |
| ADDANKI | R7 | C1 | 45 | 38% | Top 80% |
| ADDANKI | R8 | C2 | 26 | 22% | Top 80% |
| ADDANKI | R5 | C1 | 21 | 18% | Top 80% |
| ADDANKI | R9 | C2 | 13 | 11% | Rest |
| ADDANKI | R6 | C1 | 12 | 10% | Rest |
| ADILABAD | R11 | C2 | 75 | 35% | Top 80% |
| ADILABAD | R10 | C1 | 44 | 21% | Top 80% |
| ADILABAD | R13 | C2 | 33 | 15% | Top 80% |
| ADILABAD | R14 | C1 | 31 | 15% | Top 80% |
| ADILABAD | R12 | C2 | 30 | 14% | Rest |