Forum Discussion
Rank based on Cumulative SUM Column
Hi, I have this table and I need to calculate the RANK by YEAR & CYCLE depending on the cumulative POINTS by YEAR (In the example, The CUMULATIVE POINTS for CYCLE 2 are the SUM of POINTS from CYC...
Anonymous , please find the file attached, after signature
Yes, thanks
| YEAR | CYCLE | TEAM | POINTS | CUMULATIVE POINTS | RANKING |
| 2018 | 1 | A | 3 | 3 | 1 |
| 2018 | 1 | B | 1 | 1 | 2 |
| 2018 | 1 | C | 0 | 0 | 3 |
| 2018 | 2 | A | 1 | 4 | 1 |
| 2018 | 2 | B | 1 | 2 | 2 |
| 2018 | 2 | C | 1 | 1 | 3 |
Details:
Also the Ranking is based on CYCLE and YEAR
Anonymous , please find the file attached, after signature