Total Avarage

[#1]

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

[#2]

1. Make sure the chart is a Pivot Table
2. Go to the chart Properties and then the Presentation tab
3. Set 'Show Partial Sums' on the Question and Area fields

Note: This will give you an overall average for both questions, as well as an average for question 1 and question 2.

[#3]

Thank you very much for your help I appreciate your quick answer.

best regards

Malin

[#4]

One more thing Malin, Whenever you make any reports, make it a combo chart with pivot table and straight table as Fast change types. By doing this you caan show partial sums .