4 Replies Latest reply on Nov 28, 2011 1:59 AM by erinlusby0

    % Difference between 2 Years within the same measure and then as a Difference Grand Total

      I have two tables that I'm trying to get to perform a table calculation difference and percentage difference but I'm having issues with where the columns are appearing within the table. I've attached the file for your reference. In Sheet 1, I'm trying to add a column producing the difference percentage for each of the measure (ie. the percentage difference between Applications in 2010 to 2011 withing Home/EU for Fees). For Sheet 2, I'm ideally trying to produce a Grand Total as shown but instead of adding the totals for each measure, I want to show the difference. Forgive me if this is something obvious but I've not been using Tableau for very long.

       

      Thanks in advance for the help.