topic Subtotals in Application Development and Automation Discussions

Subtotals

Former Member — Mon, 03 Dec 2007 14:26:18 GMT

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.

Re: Subtotals

Former Member — Mon, 03 Dec 2007 14:30:04 GMT

Hi Amit,

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

lwa_fieldcatalog-hotspot = 'X'.

Regards,

Satish

Re: Subtotals

Former Member — Tue, 04 Dec 2007 05:23:43 GMT

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

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