4 Replies Latest reply on Nov 9, 2018 3:00 AM by alex delfabro

    how to display max sales per month per year in one row?

    alex delfabro

      Hello everyone

       

      I just want to display in one row the result (max sales per month per year)  without showing the year each time in th eresult

      I tried filter but it didn't work

       

      I created this table calculation (max per month):

       

      {FIXED DATEPART('month', [Order Date]):MAX(

      {FIXED DATETRUNC('month', [Order Date]):SUM([Sales])})}

       

      you find a picture and tbwx in the attachement

       

      THANK YOU