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?
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?