3 Replies Latest reply: Jan 14, 2018 12:38 AM by Thiago Justen Teixeira RSS

    Populate result for latest 12 month

    ahmad albab

      I want to show only latest 12 Month. But it show all data. Please help.

       

      This is my dimension:

       

      Month

       

      This is my expression for measure:

       

      sum({$<Month={"$(='>=' & Max(Month-13) & '<=' & Max(Month))"}>} [Number of Project])


      Capture.JPG