Hi all,
I have a requirement to change few fields in existing ALV.
1) i have data like this in ALV.
GROUP G/L ACCOUNT LC USD
100 10 5 5
100 11 6 4
100 12 3 3
100 11 3 2
200 10 5 5
200 11 6 4
200 12 3 3
200 11 3 2
now for particular GROUP (ex: 100) i need the sub totals of LC(5633=17) and USD(5432=14)
it should be shown before the GROUP 200 begins.
now the output should come as:
GROUP G/L ACCOUNT LC USD
100 10 5 5
11 6 4
12 3 3
11 3 2
TOTAL 17 14
200 10 5 5
11 6 4
12 3 3
11 3 2
TOTAL 17 14
Is there any way to do this..please help
thanks,
prasanth