Grand Total in Pivot table

[#1]

Hi Team,

I want to do the sum of all the four E+I+P columns. that is finding grand total.

I am not getting the solution for the same. Please help me

I have attached my qvw file.

Regards

Priyanka

[MK_QSL]

WHAT your are getting for

E+I+P

[PrashantSangle]

Hi,

In attached QVW it is working.

What is the issue??

which value you are getting wrong??

Regards

[giakoum]

looks correct to me

what do you expect to see?

[#5]

Hi Manish,

I want a column called Grand Total which will be  Embedded system (E+I+P) + Information security (E+I+P) + Virtualization (E+I+P) + Ethical (E+I+P)

i.e. 155+92+83+92 = 422

[PrashantSangle]

Hi,

Go to presentation Tab-> Select Subject ->check Partial Sum

Regards,

[giakoum]

=sum({<Ex_Type={'External','Internal','Practical'}>} TOTAL <Student> Marks)

[#8]

Hi ioannis,

Thanks for your reply.

The expression that you have provided gives me correct output, but the problem is that Grand Total column is displayed below all the subjects.

Attached is the screenshot for your reference

Regards,

Priyanka

[#9]

Hi Max,

The partial sum check box is disabled.

Regards,

Priyanka

[giakoum]

Alternatively you can make it a calculated dimension :

=Aggr(sum({<Ex_Type={'External','Internal','Practical'}>} TOTAL <Student> Marks), Student)

most likely this can be simplified further