2 Replies Latest reply: Feb 7, 2018 12:56 PM by Sudeshna Salian RSS

    Display the total sum for each product based on Year Quarter

    Sudeshna Salian

      I have three variables - Products, Price and YearQuarter. I need to display the total sum for each product based on Year Quarter. I am trying to find a way to aggregate the sum of each year and display the totals. As of now, I see the total amount for all.

       

      Product2016-Q12016-Q22016-Q32016-Q42016 Total2017-Q12017-Q22017-Q32017-Q42017 Total
      X
      Y
      Z