2 Replies Latest reply on Aug 15, 2018 1:16 PM by Jim Dehner

    Last Date Selected?

    Greg Mooney

      I would like to be able to have a calculated dimension that will tell me the last date selected via a filter for a particular worksheet.

       

      I already have a calculated dimension called last date selected but it basically is just finding the most recent week of data

       

      {fixed :max([Date])}

       

      My workbook has data through week ending 8/4/18 but I have a worksheet that is filtered with 13 weeks and the last date of that filter is 7/14/18.

       

      How can I created calculated dimension to give me the "last date filtered" is 7/14/18?