7 Replies Latest reply on Mar 7, 2018 6:54 AM by naresh.suglani.0

    Difference between 2 columns in a 3rd column?

    naresh.suglani.0

      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.