1 Reply Latest reply: Sep 20, 2017 12:09 PM by youssef belloum RSS

    Only display a dimension value in a specific date

    Mandi Hu

      Hi,

       

      I have encountered a problem. I have a table like below,

       

      ItemTypeActionQtyReportDate
      Aabcaaa10009/11/2017
      Acdeaaa20008/31/2017
      Bccccaabb40009/11/2017
      Bccccddee30008/31/2017

       

       

      I only want to display rows with max ReportDate in a table. like:

      ItemTypeActionQtyReportDate
      Aabcaaa10009/11/2017
      Bccccaabb40009/11/2017

       

      ReportDate is dynamic, Type and Action are character values, so I don't know how to restrict them to a specific date with set analysis when adding them as measures or if statement when adding them as dimension,

       

      Thank you,

      Mandi