Skip to Content
avatar image
Former Member

Sum by row in report (Analytic)

Hi Experts,

I have the requeriment that reflect in the follow example of report:

Column 1 | Column2

2             | 4

5             | 7

8             | 9

I was created the follow key figure:

"Column1"*"Column2"

The SAP C4C made the follow equation:

(2+5+8)*(4+7+9) = 15 * 20 = 300

But I need that the system made the following equation:

(2*4)+(5*7)+(8*9) = 8+35+72 = 115

Can any body help ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jul 21, 2015 at 11:14 PM

    Our expert has recommended to read up and leverage exception aggregation in the Analytics guide to achieve the desired end result.

    Thank you.

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 21, 2015 at 01:44 AM

    Hi,

    While creating Calculated Key Figure you can choose Calculate Result as Summation/Total under Properties (Step 3).

    Hope it helps..

    Thanks,

    Raju


    KF.png (24.0 kB)
    Add comment
    10|10000 characters needed characters exceeded