Subtotals

[Former Member]

Hi,

In the ALV when I click the subtotal on a column(Material Group), the subtotaling happens on the basis of material group and yellow line appears.

Also there is a facility to drilldown(expand or collapse by clicking <u><b>|</b></u> icon which appears on the extreme right on the yellow line of the subtotal). Generally a hand like icon appears when the mouse pointer is moved towards it.

In my case I don't get that hand like icon and is unable to collapse or expand. I am able to drilldown sum level from the button available on the ALV toolbar.

Please help me how I can get the drilldown sum level facility on the ALV grid by clicking the mouse.

Regards,

Amit Behera.

[Former Member]

Hi Amit,

You need to Pass 'X' to the field catalog for that field

lwa_fieldcatalog-hotspot = 'X'.

Regards,

Satish

[Former Member]

SUBTOTAL is the TOTAL at perticluar level.

TOTAL means TOTAL of all the lines.

LIKE:

N1 100

N1 200

N2 100

N2 500

Subtotal

N1 300

N2 600

Total

• 900

To get the SUBTOTAL in the ALV you need to use the SORT tables.

In the SORT table you can find a parameter SUB_TOT. Just pass 'X' on which you want to have an subtotal. Like in the about example FLD .. pass 'X' to SUB_TOT,

To get the TOTAL .. pass FCAT-DO_SUM = 'X' for the amount fields.

b]How do I add subtotals

http://www.sapfans.com/forums/viewtopic.php?t=20386

http://www.sapfans.com/forums/viewtopic.php?t=85191

http://www.sapfans.com/forums/viewtopic.php?t=88401

http://www.sapfans.com/forums/viewtopic.php?t=17335

http://www.sapdevelopment.co.uk/reporting/alv/alvgrid_basic.htm