7 Replies Latest reply: Oct 9, 2018 6:00 AM by Ron M RSS

    Addition of different years data

    Ron M

      Hi Guys,

       

      I am working with 2 dimensions trying to create a stacked chart. One dimension is year (2016-2018) and the other dimension is product type with a total of 3 products. I want the stacked chart to be an addition of all the years data. For example, the value of Product 1 in the stack should be its total value for the 3 years. There needs to be only one bar/column for all the 3 years combined. How can I achieve this using an expression? Please advice.

       

      Best Regards,

      Rony