i need previous 3 months data..(set analysis)

[#1]

Hi community,

I have a problem that is, when ever i select Year and Month then i need previous 3 months data.

Example:

year     :2012

Month     : Sep

  Now i need sum of previous 3 months :    Aug+July+Jun .

Thanks ,

satti

[sushil353]

Hi,

Please find the attached app.

Hope that helps you.

Sushil

[kaushiknsolanki]

Hi,

     Use the expression like shown below.

     sum({<Date = {">=$(=Addmonths(makedate(max(Year),Max(Month)),-3))"},Year=,Month=>}Sales)

Regards,

Kaushik Solanki

[#4]

Hi Kaushik Solanki,

I have used sushil kumar's attached Application to check our Expression. but i did not get expected result.

Could you plz check expression with attached Application.

Thanks and Regards,

      Satti

[jagan · Accepted solution]

Hi,

Try like this

sum({<DateFieldName = {">=$(=MonthStart(Max(DateFieldName), -3))<=$(=MonthEnd(Max(DateFieldName), -1))"},Year=,Month=, Quarter=>}Sales)

Hope this helps you.

Regards,

Jagan.

[#6]

thanks Jagan

   It's working  .