Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to do a rolling value

I have some values which are separate for each of the months. However I would like it to be displayed in a rolling total so January would simply have January's figure in but February would have their value in as well as January's.

Month
Value

Expected

Value

Jan22
Feb35
Mar27
April18
1 Solution

Accepted Solutions
CELAMBARASAN
Partner - Champion
Partner - Champion

Use Month as Dimension.

Expression Label: ValueExp

Expression : Alt(Above([ValueExp]),0) +Sum(Value)

Or

Use Fully Accumulated option in the Expression tab under Accumulation section.

Hope it helps

View solution in original post

2 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Use Month as Dimension.

Expression Label: ValueExp

Expression : Alt(Above([ValueExp]),0) +Sum(Value)

Or

Use Fully Accumulated option in the Expression tab under Accumulation section.

Hope it helps

Not applicable
Author

yeah.

Good answer........

Regards,

Kabilan K