11 Replies Latest reply on Dec 11, 2019 3:39 PM by Abby Nie

    Add another calculated row in the text table

    Abby Nie

      Hi all,

       

      I am trying to compare the sales for three fruits. The data is like this

       

      Fruits data.PNG

       

      What I have for now is:

       

      Table I have.PNG

      My desired output is a table with the difference of sales between 2018 and 2019, such as the following:

      desired output.jpg

       

      The difference is the [sales in 2019] - [sales in 2018].

       

      Can some one help me to achieve this?

       

      Thanks!

       

      Abby