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 .