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?