how to show latest 5 months of data dynamically?

[pgrs4219]

Hi Community,

I have a requirement that i need to show the latest 5 months of data,here is the formula that am using that for that

= IF([Month End Date]>=$(#=Date(Max({1<Month_End_Date={"<=$(Date(vMonthEndSelected))"}>} Month_End_Date,5),'DD MMM YY'))

AND [Month End Date]<=Date(Date#('$(vMonthEndSelected)','DD MMM YY'))

,[Month End Date]

Here vMonthEndSelected=max(Month End Date)

But am unable to to show the latest 5 months of data dynamically.any one can help me where exactly the problem is please.

Thanks

[sunny_talwar]

Can you share screenshot of with and without selections?

[pgrs4219]

here i have selected the june -16 but still its at the max(month).its not changing dynamically

[sunny_talwar]

Not entirely sure, but if you can share a sample, I can try looking into it.

Best,

Sunny