8 Replies Latest reply on Dec 28, 2018 7:22 AM by Roger Pouly

    Difference between 2 columns in a 3rd column?


      Hi all, I have data in a table by region, split by product types and then by 2 different years as a % of row for the specific year. I would like the difference in % between the years for each of those product types in a 3rd column for each product type if possible. Then if I could change the value in that column to a symbol (arrow up or down) that would create my perfect result.


      Can this be done?


      I have attached a screenshot as the packaged workbook is too large to upload.