09-04-2008 12:57 PM
HI FRIENDS ,
I m creating ALV grid report. in that
i have to get the following output.
no problem with value 1 field.
1. but value 2 field should be common for both 2 records. i cannot use sort option because i have to find subtotal of value 2. if i use sort option then value 2 records (2419.46 +2419.46) will get added .that is wrong.
2. next difference = value2 - value1. but it should be displayed with subtotal output.not as actual record..
how to do this .. if u know pls let me know..
thanks and regards,
kani.
VALUE 1 VALUE 2 DIFF
1200.73
1200.73 2419.46
2400.46 2419.46 19 SUBTOTAL
12
12 28
24 28 4 SUBTOTAL
09-04-2008 1:02 PM
case 1 and case2 will be possible with the help of SUBTOTAL_TEXT event. inside the event you can modify the SUBTOTAL values.
For case1 there is direct solution , if the value repeats then you can take the average of that.
for Getting the average you can use the DO_SUM option in the fieldcatalog level.
FCAT-DO_SUM = 'C'. "<----This calculates the Average,