5 Replies Latest reply: Oct 27, 2015 5:28 AM by Andy Weir RSS

    Question on pivot tables (Total row and additional column)

    Homer Cruzado

      Hi,

       

      I'm new with QlikSense, I made a pivot table for the scores of each student for three types of exam.  Below is a sample data:

       

      Student/SubjectExam 1Exam 2Exam 3Total% of Overall
      Student A55515

      15/36 = 41.6%

      Student B3251010/36 = 27.8%
      Student C5331111/36 = 30.6%
      Total13101336

       

      Need some help on the following items:

      1. I can't seem to find any option to put the TOTAL row and column to the end of the table, unlike in straight tables where I'm able to choose where I want the TOTALS to appear
      2. Is there a way to add a column to show the percent of each student's total score to the overall score? When I tried defining a new measure, an additional column appeared for each exam type

       

      Thanks in advance!