4 Replies Latest reply on Jan 28, 2013 7:45 AM by Joshua Milligan

    sum of two columns into a third column in table

    Syed Shah

      Hi,

       

      I have a pivot table which shows grade in rows, categories in columns and percentage of each category as values for example see the below table. So I have to show Grade, categories in each grade (outstanding, excellent etc) and percentage of students in each category of performance in each grade. The fields are below

       

      Grade

      PerformanceCategory

      Performance% (Performance percentage calculation)

       

       

      Grade
      OutstandingexcellentgoodaverageOutstanding+Excellent
      120%10%30%40%?
      210%20%20%50%?
      310%10%20%60%?

       

      I have a pivot chart as above in my tableau report. Now I want to add another category which is the sum of excellent+outstanding categories.  I have created another measure which sumsup the percentage of excellent + outstanding students. However The issue is that how can I show the extra measure as the last column (Outstanding+exellent). If I have to show it without adding the extra measure, then how can I do that?

       

      When I add the extra measure, it just messesup the shape of the pivot table and does not show up as the last column above

       

      Any help will be appreciated here

       

      Regards

      Shah