Hi All,
We got one requirement to build report based on GL and amount (coming from source) in such a way that GL gets split based on below highlighted XYZ, ABC, EFG (which is not coming from the source). I tried with Bex Query designer Structure, But no luck
Could you please help me how to get the expected result.
XYZ
Amount
10009
72
10010
74
10020
2
10021
800
10011
500
10012
20
ABC
35156
720
35164
740
35157
20
35165
8
35158
50
35166
2000
EFG
20009
7200
20010
7
20020
2
20021
8000
30011
5
50012
20