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