Cumulative value restricted to months where data is available

Question & Answer
, ,
1

Hello,
I want to calculate the cumulative for Actual but only till the month actual is available (which is 5) after that it should not show the cumulative values.

Cumulative_Sample

Thanks in advance.

2

Hi @VivekN and Welcome to the QuickSight community!
I added an ifelse statement to your existing calculated field to accomplish this. Essentially, the change checks if your current is not null, then provide an ActualYTD, otherwise leave as null. That way, unless there is data in your current column, it will also leave the Actual YTD blank as well.

Calculated Field:
ifelse(isNotNull(Actual), runningSum(sumIf(Value,Type='Actual'),[Month ASC],[Dept]), NULL)

Updated Analysis:
Cumulative Value Restricted to months where data available

I’ll mark this as the solution but let me know if you have any additional questions!

1 Like