Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can you share screenshot of with and without selections?
here i have selected the june -16 but still its at the max(month).its not changing dynamically
Not entirely sure, but if you can share a sample, I can try looking into it.
Best,
Sunny