8 Replies Latest reply: Jul 17, 2018 6:04 AM by vishal goud RSS

    Question on pivot tables (Total row and additional column)



      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%


      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!