Forum Discussion

kkalyanrr's avatar
kkalyanrr
Icon for Helper V rankHelper V
5 years ago

Setting month filter to current month by default

Hello, I'm having a report page with year and month filters,Is there any way I can set up this page in a way that it shows current month selected by default(not through relative date filtering las...
Need Help
Show and Tell
Tips and Tricks
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

kkalyanrr , You have to create a column like this in you date table

Month Type = Switch( True(),
eomonth([Date],0) = eomonth(Today(),-1),"Last Month" ,
eomonth([Date],0)= eomonth(Today(),0),"This Month" ,
Format([Date],"MMM-YYYY")
)

and use this to select This Month. You can sort this on month year sort