13 Replies Latest reply: Mar 18, 2016 7:21 AM by Gysbert Wassenaar RSS

    Comparison sum sales in Year with Previous Year

    Tatsiana Chetirbok

      Hi!

      I need to create straight table where Dimensions are Customer, Product, Storage, Year

      and Expressions are sum(Sales) in Year and sum(Sales) in Previous Year.

       

      Something like this:

      where number in column F is Sales in 2015 and number in column G is Sales in 2015 -1

       

      Any idea how can I do it?

       

      Many thanks!