Skip to Content
0
Former Member
Aug 02, 2013 at 04:57 AM

Adding up values based on the other 2 columns in a WEBI report

2393 Views

Hi All,

I have a report similar to the table below.

Name Desc
Amount
A abc 100 A abc 200 A abc 300 B xyz 100 B def 200

Im trying to get the output as below. For Name as 'A' and for Desc as 'abc', the Amount should be added up and has to come in 1 single row i.e

A abc 600.

Name Desc
Amount
A abc 600 B xyz 100 B def 200

Im trying out combinations of sections and breaks to do this.

But not able to achieve i 😔

Any ideas on how to achieve this or if some 1 has already done this kind of implementation, please let me know.

Thanks

Shreyas