10 Replies Latest reply on May 13, 2014 6:23 AM by John Huynh

    comparing periods over multiple measures for 3rd colum as % of Difference

    William Ohara

      I want to compare periods Q1 2011 to Q1 2012 by adding a 3rd column which is % of difference similar to a row grand total column.

      I cannot come up with a way to solve this easy add.


      See below is a simple excel calculating the difference across the rows ..% of Diff...How do I get add a column to do this????


      I am posting again because I cannot see my other post..




      Year of DOS_MONTH
      cat20112012% of Diff
      avg sales$279.27$378.1135.4%