Open Report to Current Month's Data

[Lamda]

Hey All,

So I have a report that has a rolling 12 months worth of data. It currently just opens up with all the data showing, the slicers show all, etc. I have a request to see if it can be opened up to the most current months worth of data. Is there a way to filter the slicer automatically to show the most recent worths data? I could obviously open the file and manually do it but this will go on a share site and let it autorun itself so i'm trying to figure out a way to do this.
So any suggestions on how to have my file open up filtered to the most current months worth of data?

 

[Matt Allington]

In your calendar table, you need a column that identifies the current month. Typically you will have a month column like YYMM. Then you could write a calc column that uses today() to identify the current month, and based on that you can create a column that has YYMM for all other months other than "current month". Every month that you refresh the data, the "current month" label moves to the next month based on the formula. Because the "current month" label is always in the slicer, it will remain selected. Does that make any sense?