Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Chk with this
Hi,
Accumulation computes the calculation based on the values displayed in that table.
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.
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?
I make this to illustrate the problem.
Thanks for help
Did you try calculating the cumulative values in the script?
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?
see attached
do that with sum expression:P
Chk with this