Skip to Content
0
Former Member
Sep 06, 2011 at 11:44 AM

sum in BEx query

28 Views

Hi All,

I have Account and amount in my BEx query, Where accounts will start with X or Y or Z. user will enter any of the accounts.

In my output I want see X accounts (assumin that all accounts starting with X belongs to X group, Y belongs to Y group and so on) sum in one row and Y accounts amount sum one more row and so on...

I do not have account group in my flow and dont want to be derived in data flow based on account. Thanks

Please helpe me to achive the same .

Regards,

J B