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..

       

       

      Bill

      Year of DOS_MONTH
      cat20112012% of Diff
      sales$172,587.91$229,513.4833.0%
      avg sales$279.27$378.1135.4%
      PMPM$0.014$0.01934.4%
      units618607-1.8%