1 Reply Latest reply on Feb 9, 2019 6:51 AM by Sean Miller

    Adding a custom % difference column

    Baz Sukhbaatar

      Hi everyone,

       

      I currently have a worksheet table showing three different category types with two different period ranges on the columns shelf showing two measures as rows. I would like to add an additional column calculating the percentage difference from period to period for each category. So there would be a percent difference column after period 2 for each category. Can anyone help with this or know of any workarounds? I've attached a sample workbook and see below for what I'm trying to get at. Thanks

       

       

                   

                                           Category 1                                       Category 2                                  Category 3
      Period 1Period 2% ChangePeriod 1Period 2% ChangePeriod 1Period 2% Change
      Measure 1          2,188,629             304,505▲ 86.09%      4,049,361550,361▲ 86.41%   3,826,405          526,744▲ 86.23%
      Measure 2             985,134             126,092▲ 87.20%      1,636,945217,862▲ 86.69%    529,611            70,467▲ 86.69%