Subtotals in two rows Alv grid

[Former Member]

Hi Every one,

I want to display subtotals in ALV grid in two rows.

One total is in Mins and another total is in hours.

I have time fields at record level.

thanks in advance.

[Sm1tje]

If minutes and hours are in a separate column, the ALV functionality (button sigma) will do the rest. But make sure that hours and minutes are not of type c. Should have a numeric type, else these can't be added up.

[Former Member]

I have columns like OFF-STD time,Non Std-time etc all these fields are in mins only.

when use sort and subtotal functionality it will display the subtotals in mins only but i want to add one more subtotal row which will display the subtotal in Hours ie mins/60.

Guide me how to achive this.

[prasanth_kasturi]

in fieldcat pass do_sum parameter

and populate the sort table

using the fieldname and subtot

reward if helpful

regards

prasanth

[Former Member]

Hi Prasanth,

thanks for your reply.

if i do as u suggested it will display the subtotals in one row i.e. in Mins but i need one more row which will display in hours