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

[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 https://answers.sap.com/questions/206093/index.html , Where its working fine while using Summarized option as Sum .

Please check image file and advise .

[abhilash_kumar]

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);
addn; 

-Abhilash

[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.

[Former Member]

Hi Abhilash,

Could you please help me to sort out this.