Set Analysis

[spividori]

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.

[MayilVahanan]

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)

[swuehl]

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..

[spividori]

Sorry
Here is my example with data.

Regards.

[johnw]

Unless I'm misunderstanding, just set Accumulate 3 Steps Back on the Expressions tab.  That seems like the easy way, anyway.

[spividori]

I tried also to select a month you also add the three above.

But will use the rangesum (). Thank you all.

Regards.