ALV -- Do Sum ?

[Former Member]

Hi experts,

In my ALV output, I have done sub-total for all the fields using int_FCAT-do_sum = 'X' in field catalogue. I dont want the values to be displayed in output. I need to display only the total sum values at the end. How to hide the values in the column other than sum values at the end in ALV?

For e.g if the alv is shown as below:

1 12 1

2 10 1

3 20 1

-

---

6 42 3

-

---

2 01 1

3 05 3

-

---

5 06 4

In this above output how to hide the values in column 1 that is how to hide the values 1,2,3 in and how to hide the values in 2 & 3. But I need to display the subtotal values 6 & 5 at the end.

Regards,

Sakthi

Edited by: Sakthi Saravanan C on Jan 11, 2009 1:23 PM

[Former Member]

This message was moderated.

[I355602]

Hi,

Use parameter totals_only in slis_layout_alv if using REUSE_ALV_GRID_DISPLAY.

Double click from report program on slis_layout_alv and then double click in slis_layout_alv_spec and then click slis_layout_alv_spec1.

Here you can check the section for Sums and use totals_only(1) type c, " show only totals.

Hope this helps you.

Thanks & Regards,

Tarun Gambhir

[Former Member]

you can do one thing

insted of writing FCAT-do_sum = 'X' , you can write the logic to do the sum of your column

and then append that sum atyour internal table,

[Former Member]

Go thru dis link...

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

[Former Member]

Problem solved thank you