How to display past records based on current selections?

[baarathi]

How to display past records based on current selections?

For example, if we select a particular year-month, previous 3 or 4  months details should be displayed....

[Anil_Babu_Samineni]

Perhaps this?

Sum({<[year-month] = {">=Condition <= Condition"}>} Measure) // Here, condition you can use as per needs

[tresesco]

Check it here: Selected Dates Range for idea.

[baarathi]

Thanks a lot

[baarathi]

Thanks a lot but sir,is there a way other than using set analysis?

[baarathi]

Sir... Should we apply this query as dimension or expression?

[tresesco]

Ideally - expression.