Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SUm Measures based on Same dimension Value

Hello all,

I have looked for an answer to this, but not getting what I am looking for.

this is an example of data

  Dimens1    Dimens2       Measure1     Measure2     Measure3
   a             b               1            2            3
   a             b               2            3            3
   a             b               1            4            1
   c             d               2            4            5
   c             d               3            2            1
   c             d               2            2            4


What I want is:

  Dimens1    Dimens2       Measure1     Measure2     Measure3
   a             b               4            9          7
   c             d               7            8          10

I have tried using 

=Sum(Measure1) forEach(Dimens1)

Do I have to do something like this for each Measure?

It didnt make any changes. Could anybody help me achieve this?

Thanks in advance,

Niraj

Edited by: NirajK on Mar 15, 2011 10:04 PM

Former Member
Not what you were looking for? View more on this topic or Ask a question