problem in alv

[Former Member]

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

[former_member188685]

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,