3 Replies Latest reply: Jan 19, 2010 6:37 AM by silky.agarwal RSS

    Total Avarage

    MalinSmith

      Hi,

      I am new in QlikView, so I would likt to have some help with the total avarage in a straight table. For now I the table is look like this:

       

      Question

      Area

      Avarage

       

       

       

       

      Total : 65

       

       

      Question 1

      Area 1

      67

       

       

      Question 1

      Area 2

      69

       

       

      Question 1

      Area 3

      60

       

       

       

       

       

       

       

       

       

       

       

       



      But I want to have the table which look in this way:

       

      Question

      Area

      Avarage

       

       

       

       

       

       

       

      Question 1

      Area 1

      67

       

       

      Question 1

      Area 2

      69

       

       

      Question 1

      Area 3

      60

       

       

      Total

       

      65

       

       

      Question 2

      Area 1

      74

       

       

      Question 2

      Area 2

      80

       

       

      Question 2

      Area 3

      75

       

       

      Total

       

      71

       

       



      could anyone please help me with this? (sorry for my english)

      Thank you in advance!

      Best regards

      Malin