4 Replies Latest reply on Oct 3, 2016 11:19 PM by Crystal Ng

    Difference between two columns

    Crystal Ng

      Hi All,

       

      I'm trying to calculate the difference between two columns in a table. The two columns are the 'Market Share %' calculated based on the volume, and I would like to know the Market Share increase (Simply 2016 minus 2015).

       

      But since these two columns are calculated fields based on volume, I'm not able to perform another table calculation for the column difference.

       

      I'm not keen to add market share to my data source as a lot of the calculations are of different segments.

       

      Thanks for your help.

       

      Crystal