Forum Discussion

Rajesh_R1's avatar
Rajesh_R1
Frequent Visitor
5 years ago

running total for specific value

Hi,   I have the below table, in which i calculated the running total. Can any one suggest how to create a seperate measure which filter only the Running total value when  SOTAT days at 1?    ...
Need Help
Rajesh_R1's avatar
Rajesh_R1
Frequent Visitor
5 years ago

 amitchandak Many Thanks Amit,

 

I have already calculated the Running total, what i am looking at some thing like below. A measure to show  what is the %GT Running Total alone when SOTAT Days at 1

 

 

Thanks and Regards,

Rajesh

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      HI Rajesh_R1,

      Did you mean to show the rolling total on the row which has the special category type values?
      If that is the case, you can write if statement to check the current type to navigate to different calculation formulas. (other types to common calculation, specific type to rolling total)

      Regards,

      Xiaoxin Sheng