Cumulative sum over a dimension

[#1]

I have a pivot table with a dimension [Year]. The expression in the pivot table is the sum of revenues: sum(Revenue). Instead of having the sum of revenues for 2010 to 2014, I would like to have the cumulative sum over years starting in 2010.

I cannot use the Accumulate option because I am using the Full Browser version and there seems to be no such option in the Full Browser version.

Thanks in advance

[Gysbert_Wassenaar · Accepted solution]

The accumulation option will work in webview too. But perhaps it's easier to enable the option in normal view. If you don't want to use the accumulation option then have a look at this document for some alternatives: Calculating rolling n-period totals, averages or other aggregations

[#3]

Thanks for your reply.

Do you know where I can find the option in the Full Browaser mode ?

Thanks for the link, will look at it

[Gysbert_Wassenaar]

Under Expressions select an expression and click the More button. You'll find an Accumulate Expression option. Click on the sprocket wheels to change the properties for the accumulation option.

[#5]

Thanks for your quick answer.

Maybe we do not talk about the same kind of visualization, or maybe it is because i have limited edition rights... In the Full Browser version i have, there seems to be no such option for accumulate... Below is a screenshot

would you have a further idea where the option could be in this Full Browser version ? there are a lot of options, it is strange that accumulate option is not available as well...

[Gysbert_Wassenaar]

Ah, I see now you're using a pivot table. Pivot tables don't have an accumulation option at all, not in webview, not in normal view.

[#7]

Thanks for this. Also are alternative options (with an expression) possible in pivot table ?

[Gysbert_Wassenaar]

See the document I referred to earlier.