maximum value in ALV

[Former Member]

Hi Friends,

I have some requirement like below...

ABC JACKSON 1000.00

ABC DENNY 2000.00

ABC KELVIN 0.00

• 2000.00 (subtotal should display Max value in that column)

i mean in the ALV output i needs to display the subtotal as Max value for ABC...and so on.

I would like to know that there is any option like do_sum,sub_tot ........ in ALV field catalog..?

kindly help me to resolve this...

[former_member188685]

it is possible. but there is no special option for it. you have to use the DO_SUM option of the fieldcatalog.

DO_SUM = 'A' "for maximum

DO_SUM = 'B' " for minimum

DO_SUM = 'C' " for Average

DO_SUM = 'X' " for totals

check it once.

[Former Member]

Thanks ....but i have one question... that you mentioned as do_sum... i.e only for entire column sum right...? but for me i needs to show at sub_total level.. Maximum value..

please confirm it... 'A' 'B' 'C' will work for both...?

Edited by: murali krishna on Oct 13, 2008 5:30 AM

[former_member181995]

No.Do_sum =A,B,C.. would work only with the ALV column values not for the sub total values.