Skip to Content

Merge to Single records

Hi Experts,

Attached webi screenshot for your reference

My issue is iam trying to merge these similar records to an single record ignoring the Not Assigned department so that fund amounts are summed up without changing the design.

Could you please help with an key figure formulae for Fund1, Fund2, Total so that amounts are summed up, resulting to an single record.

I donot want to apply break or remove any dimension column basically i am looking for an formulaes without changing the design.

Thanks,

Dinya

capture.jpg (25.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    May 07 at 05:29 PM

    Hi,

    Try this:

    Grand Total:

    =Sum([Fund1]+[Fund2]) in ([Emp ID])

    you can now take out measures and insert "Grand Total" variable.

    If you see an extra row.. Try Max([Grand Total])

    Thanks,

    Jothi

    Add comment
    10|10000 characters needed characters exceeded

  • May 07 at 08:32 AM

    Hi,

    can you try this one please

    https://blogs.sap.com/2014/05/08/aggregated-dimension/

    Grtz

    Koen

    Add comment
    10|10000 characters needed characters exceeded