Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI!
In my example I have a table with dates and quantity.
I read the date as Month Year and then arm a bar graph with this dimension.
Need for each dimension that adds the previous two.
For example: in June 12 should add April 12, May 12 and June 12.
I wish I could do it with Set Analysis.
Regards.
HI
I can't able to see the fields in your example file.. Try like this
=sum({<Date = {'>=$(=vTest)<=$(=vTest1)'}>}Quantity)
where vTest = AddMonths(Min(Date),-2)
vTest1 = Max(Date)
Set analysis won't consider your current dimension value, because it's evaluated once per chart.
I think the way to go is using chart inter record functions like above().
Try something like
=rangesum(above(sum(Quantity),0,3))
edit: changed 2 to 3, you requested summing 3 Months..
Sorry
Here is my example with data.
Regards.
Unless I'm misunderstanding, just set Accumulate 3 Steps Back on the Expressions tab. That seems like the easy way, anyway.
I tried also to select a month you also add the three above.
But will use the rangesum (). Thank you all.
Regards.