Skip to Content

How to display avg total in cross tab while using max of summarized fields

Jun 07, 2017 at 05:59 PM


avatar image
Former Member

Dear Experts ,

In Cross tab summarized field , i am using maximum summary option . In Total i want to display Sum of total value .

I refer answer from this post , Where its working fine while using Summarized option as Sum .

Please check image file and advise .

1.jpg (255.7 kB)
2.jpg (31.1 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Abhilash Kumar
Jun 08, 2017 at 08:24 AM

Hi Sri,

Right-click the value in that 'Total' cell > Select Calculated Member > Edit Calculation Formula > Paste this code:

local numbervar i;
local numbervar addn;
for i := CurrentColumnIndex to GetNumColumns-1 do
    addn := addn + GridValueAt(CurrentRowIndex, i , CurrentSummaryIndex);


Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Abhilash ,

Above Formula is working perfectly for the year total of 2017 , but for the value of 2016, it's displaying the wrong total.

Please check the last two row in the attached image file, total for 2017 - 19 is correct, the total for 2016 is 60 but its display 86.

Please suggest.

sum.jpg (311.2 kB)
Former Member

Hi Abhilash,

Could you please help me to sort out this.