Add previous 2 months values on selection of particular month

[#1]

Hi Experts

I want values of previous  2 months  on selection of particular month.It should group by month wise.

On clear selection also it should display last 3 months which i got from following expression:

(Aggr(Sum({< link_Date={">=$(vLast3Months)<=$(vCurrentDate)"}, [Fiscal Year]=, [Fiscal Month]= >}

Sale),[Fiscal Year], [Fiscal Month], link_Dealer))

For example on selection i want , If i select jan 2015 then it should dislpay data of jan 2015,dec 2014,nov 2014

on the selection jan 2015 .

plzz give the solution fast its urgent. Im getting stuk in this problem.

Thanks in advance.

[sunny_talwar]

So if you are seeing Nov 2014, Dec 2014 and Jan 2015 then what is the problem??? You are seeing last 3 months when you select Jan 2015, isn't that what you wanted??

[#3]

Thank u so much for giving your precious time.Yeah getting the values also.

Now i want count of those employees whose values come in that 3 months only.

My expression is:

=If((Sum({< link_Date={">=$(vLast3Months) <=$(vCurrentDate)"} ,[Fiscal Month]= ,[Fiscal Year]= >}Sales))<30,1)

I want only those employees whose sale comes into selected month and previous 2 month.

Means count of only thoes employees whoes value comes in 3 months.

Even if for particular employee value comes for eg. <30 for only in 2 months then that employee should not be counted.

[sunny_talwar]

You want to count employees who have above 30 sales in all three months??? Is that what you wanted?

Best,

Sunny

[#5]

exactly