How to use partial sum in Pivot table

[Anonymous]

Hi,

I am using Pivot table to show this type of excel data. The two dimension are Math and Percentage. My problem is that how can we show coulmn Average which contains average of only Percentage ,not Math.  I also want to show Sum of all Percentage in last Row.

How can we achieve this in Qlikview.

Regards,

Samay

[#2]

could you send small sample qvw file?

[Anonymous]

I have uploaded my sample file.

Sorry for Typo. I want to say that two expression are Math and Percentage in my preivous comment

[#4]

first case you can make by :

=if(Dimensionality()=2, Sum (Math),'')

as an expression

[Anonymous]

Hi  Pari,

Thanks for your quick reply.i tried ur solution but it does not work.

I want the same representation in qlikview as it is in attached image.i have to show only Avg of Percentage in Coulmn I , and Sum of Total percentage as in Row 13.

[#6 · Accepted solution]

see att file

it's almost exact what you want

i believe one extra row with Math in total will not be a problem:)

[Anonymous]

thanks pari for your reply. this is exactly what i wanted. Thanks a lot again..:)