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,