ALV grid using Object oriented programming

[Former Member]

Hi,

I need to display a report with 14 fields of which some fields need sub totals and some fields need average values and some other fields require both subtotals and totals. But if I need only the subtotals. I'm not able to find a way for doing so. Please help.

Thanks and regards

Radhika

[Former Member]

You will have to specify DO_SUM = X for the fields which you want to totalled or sub-totalled and set DO_SUM = C for getting the average of the field. This needs to be done in the field catalog.

Also, specify the SORT criteria for the doing the sub-totals in the IT_SORT table, of the SET_TABLE method or the user can do that himself in the report.

Regards,

Ravi

Note - Please mark all the helpful answers

[Former Member]

Hi Ravi,

I need 'subtotals only' for some fields, but subtotals and totals for other fields. My problem is which option do I need to check to get only subtotals for some fields and subtotals and totals for the other fields.

Thanks and regards

Radhika

[Former Member]

whichever fields you need sub totals populate those filed name s in the sort table

and for which you want totals put do_sum = 'X' for that field in the fieldcatalog.

[Former Member]

Hi Radhika,

1 . those u need only subtotals , Specify those fields in the sort table and give SUBTOT = 'X'

2, Those u need both subtotals and totals specify them in the sort table and also in the fieldcatalog DO_SUM = 'X' for those fields.