Set Analysis

[spividori]

HI.

I have two fields: AñoMes and Cantidad. I need to show me the sum of the latest four months.

You should take as latest month, the month of the date actual. In the attached example would be taking Oct 13, Aug 13, Sep 13 and July 13.

Must be independent of any selection, if I choose Jan 13, these values ​​should not be modified.

Regards.

[tresB · Accepted solution]

PFA

[swuehl]

Maybe like attached, using this expression:

Sum({<

AñoMes = {">=$(=date(addmonths(max({1}AñoMes),-3),'MMM YY'))<=$(=date(max({1}AñoMes),'MMM YY'))"}

>} Cantidad)

[spividori]

Hi.

Thanks for responding.The two examples work perfect.

Regards.