This content has been marked as final.
Show 3 replies
-
1. Re: cumulative sum
maneesh.gaddam Jun 29, 2017 9:12 AM (in response to mendey Sai)Running_sum(SUM(measure)) should do
-
2. Re: cumulative sum
Okechukwu Ossai Jun 29, 2017 5:00 PM (in response to mendey Sai)Hi Mendey,
You can use Previous_Value to calculate the running sum and use IF statement to make the first row zero.
Step 1: Create calculated field [Cumulative Sum]
IF FIRST() == 0 THEN 0
ELSE PREVIOUS_VALUE(0) + SUM([Value])
END
Step 2: Create your view. Right click on [Cumulative Sum] and select Compute using "Table (Down)"
Hope this helps.
Ossai
-
Cumulative Sum_OO.twbx 23.4 KB
-
-
3. Re: cumulative sum
mendey Sai Jun 30, 2017 4:54 AM (in response to Okechukwu Ossai)when i do a calculation like this(1-(A/B) i need to get the value 35.42 where i am getting a value like 8.98 what i observed is when i change it to dimension it is working fine but my concern here is i need to add suffix to the number.
Can anyone please suggest me the solution.
Thanks in Advance.