2 Replies Latest reply on Nov 28, 2016 6:49 AM by John Conlon

    Table calculation with multiple measures

    John Conlon

      Hi,

       

      Please see attached for an example using the Superstore dataset.  I have a simple table with measures in the first column (Order Quantity, Profit, Sales), the month from a year ago (December 2012) as the second column, and the most recent month (December 2013) as the last column.  I'd like to create a fourth and fifth column.  The fourth column would be Variance (December 2013-December 2012) and the fifth column would be % Change.  If I were only using one measure I could easily use a table calculation to do this.  But since I'm using multiple measures I'm having difficulty getting this to work.  Thanks for the help.

       

      -John