getting cumulative values in graph

[#1]

hi is there any way to add up on week by week values for example

330                        = 8/2

330+450                 =8/9

330+450+600         =8/16

330+450+600+570  = 8/23

in a line chart

[Gysbert_Wassenaar · Accepted solution]

Yes. The easiest way is to enable the option Full Accumulation for the expression. In a line chart you'd use Week as dimension, sum(Value) as expression and enable full accumulation for the expression.

[#3]

Apache,

You should be able to use the "Accumulation" setting on the Expressions tab. Highlight the the expression you wish to accumulate and select Full Accumulation.

[#4]

Hi,

With full accumulation, if you want to add a text color, what will be the code used?

If you use IF(SUM(SALES)>0, Green(),Red()) , it does not work because it retrieves the Non-Accumulated value.

If you use IF(Column(2)>0,Green(), Red()) , it still does not work.

How to account for the Accumulation for Text Color Coding when Visual Cues does not exists. (ie for Combo Charts)

Thanks