How to sum dimension values in Pivot table

[ashokpaladugula]

how can i show total sum of dimension in Pivot table. Please give me some sample.

Thanks,

ASHOK

[sunny_talwar]

I don't think it is possible without doing some manipulation...

Try this script

RNCTABLE:
LOAD * INLINE [
    Student, Exam, Points, MaxMarks
    Student A, Exam 1, 5, 10
    Student A, Exam 2, 5, 10
    Student A, Exam 3, 5, 10
    Student B, Exam 1, 3, 10
    Student B, Exam 2, 2, 10
    Student B, Exam 3, 5, 10
    Student C, Exam 1, 5, 10
    Student C, Exam 2, 3, 10
    Student C, Exam 3, 3, 10
];

Dim:
LOAD * INLINE [
    Dim
    1
    2
];

Dimensions

=Pick(Dim, Student, 'Total')
=Pick(Dim, MaxMarks, Aggr(Sum(MaxMarks), Student))
=''
Exam

Expression

If(SecondaryDimensionality()=0, Num(Sum(Points)/Sum(TOTAL Points), '0,0%'), Num(Sum(Points), '0'))

[ashokpaladugula]

Thanks for the reply.

But if i select the filters, it is not working. 

[sunny_talwar]

Which filter? And what is the expected output on selection of the filter?

[ashokpaladugula]

If i clicked any dimension, sum of dimension is not working fine.

Thanks,

ASHOK

[sunny_talwar]

Try now

[Brett_Bleess]

Ashok, did Sunny's final example app work for you?  If so, please be sure to use the Accept as Solution button to give him credit for the help and to let others know that the solution worked...  If you cannot click the button for some reason, just confirm it was what you needed, and I can mark things for you.

Regards,
Brett