Skip to Content
0
May 06, 2018 at 07:02 PM

Merge to Single records

66 Views

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

Attachments

capture.jpg (25.5 kB)