Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Running total problems

Hi,  Having some issue with running total. Can anyone suggest solution for this? I have tried something like this, but I get the same result as in totals[total_count] column: running sum = CALCUL...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    Anonymous , The data you have show stage is sortable, you can use

     

    running sum = CALCULATE(totals[total_count], FILTER(stages, stages[stage] <= MAX(stages[stage])))

     

    Or Create a stage no column

     

    stages no = right([Stage], len([Stage]) -5)

     

    and then try

    running sum = CALCULATE(totals[total_count], FILTER(stages, stages[stage no] <= MAX(stages[stage no])))

amitchandak's avatar
amitchandak
Super User
3 years ago

Anonymous , The data you have show stage is sortable, you can use

 

running sum = CALCULATE(totals[total_count], FILTER(stages, stages[stage] <= MAX(stages[stage])))

 

Or Create a stage no column

 

stages no = right([Stage], len([Stage]) -5)

 

and then try

running sum = CALCULATE(totals[total_count], FILTER(stages, stages[stage no] <= MAX(stages[stage no])))

Anonymous's avatar
Anonymous
Not applicable
3 years ago

amitchandak Thank you. Solution with stage no (index) works!