Current Quarter along with last 3 quarters

[#1]

Hi,

I wanted to display current quarter data along with last 3 quarters, how can i achieve this

[Anil_Babu_Samineni]

You meant to say this?

Sum({<DateField={'>=$(=QuarterStart(Max(DateField), -3))<=$(=QuarterEnd(Max(DateField)))}>} Sales)

OR

Sum({<Quarter = {">= $(=Max(Quarter)-3)<= $(=Max(Quarter))"}>}Sales)

[#3]

Hi ANil

Thanks so much for you reply, but here where are we mentioning Current quarter.

[Anil_Babu_Samineni]

Max(Quarter) indicates the Current Quarter only. This returns Last 3 quarters along with the Current Quarter