Skip to Content
avatar image
Former Member

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

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 .

1.jpg (255.7 kB)
2.jpg (31.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

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

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded