4 Replies Latest reply on Jul 13, 2018 10:53 AM by Ryan Blank

    Max Date in Title when MY Filter Used

    Ryan Blank

      I have a report (replicated with the Superstore data attached) where I'm trying to compare sales for the same time period YoY. I'm using MY as my date filter.

       

      What I would like to do is have a note in my sheet title that says something like "Sales Data as of Month/Year" with the date being displayed, being the last date selected. However, when I use the Max Date function, I'm getting results for the last date selected for each year (i.e. 6/30/2017 and 6/30/2018 instead of just 6/30/2018). Is there a way to get just the one, latest date?