Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks, How can I achieve the CUMULATIVE POINTS column based the previous description?

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , can you share some sample-based data

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Yes, thanks

    YEARCYCLETEAMPOINTSCUMULATIVE POINTSRANKING
    20181A331
    20181B112
    20181C003
    20182A141
    20182B122
    20182C113

     

    Details:

    Also the Ranking is based on CYCLE and YEAR

    • amitchandak's avatar
      amitchandak
      Icon for Super User rankSuper User
      6 years ago

      Anonymous , please find the file attached, after signature