how can i show total sum of dimension in Pivot table. Please give me some sample.
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 ];
=Pick(Dim, Student, 'Total') =Pick(Dim, MaxMarks, Aggr(Sum(MaxMarks), Student)) ='' Exam
If(SecondaryDimensionality()=0, Num(Sum(Points)/Sum(TOTAL Points), '0,0%'), Num(Sum(Points), '0'))
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.