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
Anonymous , Try like
Year cycle team rank= RANKX(FILTER(ALL('Table'[Year],'Table'[Cycle],'Table'[Team]),'Table'[Year]=max('Table'[Year])
,'Table'[Cycle]=max('Table'[Cycle])),calculate(sum(table[CUMULATIVE POINTS])))Thanks, How can I achieve the CUMULATIVE POINTS column based the previous description?
Anonymous , can you share some sample-based data
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