-- Chart cumulative data --

[#1]

Hello,

I have a problem about the accumulation in a chart :

the dimension is : MonthName

the expression is :  count(NUMBER_SALES)    with full accumulation 

but when I click to select just the 3 last months the accummulation change so i dont have the same result.

Anyone have an idea ?

See the example file attached to illustrate the problem.

Thanks in advance.

[CELAMBARASAN]

Hi,

Accumulation computes the calculation based on the values displayed in that table.

[giakoum]

accumulation sums what is on the chart.

you should use something like count({1<[MonthName]={"<$(=only(minstring(MonthName)))"}>} [NUMBER_SALES]) + count(NUMBER_SALES)

so that you can have previous months count regardless of what is selected.

[#4]

Hello,

I try a set analysis but this doesn't work.

With your expression I can't zoom :  MonthNames can't change in the chart.

Maybe you have another idea?

[#5]

I make this to illustrate the problem.

Thanks for help

[nagaiank]

Did you try calculating the cumulative values in the script?

[#7]

If I calculate the cumulative values in the script, i can't use filter on these values.no?

Maybe if I have another field like "Name"

and I want to see the cumul just about 1 man how I do?

[giakoum]

see attached

[#9]

do that with sum expression:P

[CELAMBARASAN · Accepted solution]

Chk with this