topic Re: ALV - Sort Aggregation Column in Application Development and Automation Discussions

ALV - Sort Aggregation Column

Former Member — Wed, 21 Nov 2007 15:18:11 GMT

Hi,

I have the following scenario.

I sorted the column 'customer' and I am using CL_SALV_AGGREGATIONS to subtotal the records by 'customer'. When I sorted 'customer', 'customer' column will appearing in alphabetical order. For example,

Customer A 1 (this is the aggregation subtotal)

Customer B 4

Customer C 3

My question is, can I sort the ALV display by the subtotal from the aggregation? Meaning I want to display the 'customer' with the most record first, like this

Customer B 4

Customer C 3

Customer A 1

Thanks!

Cady

Re: ALV - Sort Aggregation Column

former_member194669 — Wed, 21 Nov 2007 15:31:44 GMT

Hi,

Try this way


data: gr_sorts      type ref to cl_salv_sorts.
....
....

gr_sorts = gr_table->get_sorts( ).
gr_sorts->add_sort( columnname = 'CUSTOMER' subtotal = abap_true ).

a®

Re: ALV - Sort Aggregation Column

Former Member — Wed, 21 Nov 2007 15:32:33 GMT

Hi,

Instead of sorting based on Customer, sort it on Aggrigation value.

Regards,

Satish

Re: ALV - Sort Aggregation Column

Former Member — Wed, 21 Nov 2007 15:35:59 GMT

Hi a®s,

Thanks for your suggestion but I want to show the subtotal.

Cheers,

Cady

Re: ALV - Sort Aggregation Column

former_member194669 — Wed, 21 Nov 2007 15:39:56 GMT

Hi,

Try this way


gr_sorts->add_sort( columnname = 'CUSTOMER' subtotal = abap_true ).

aRs

Re: ALV - Sort Aggregation Column

Former Member — Wed, 21 Nov 2007 15:41:02 GMT

Hi Satish,

I am not getting you here. How do i sort it on aggregation value? Perhaps I am not being clear enough. Basically, i have 3 columns in the alv. Column 1 = customer, column 2 = documents for customer, column 3 = an integer 1. I am sorting column customer and aggregate on column 3. I hope I am not confusing you.

Thanks.

Cady

Re: ALV - Sort Aggregation Column

Former Member — Wed, 21 Nov 2007 15:43:21 GMT

Hi aRs ,

Yes that's what i did. In addition to that i want to sort the subtotal.

Thanks.

Cady

Re: ALV - Sort Aggregation Column

Former Member — Wed, 21 Nov 2007 15:52:20 GMT

You can't sort on the Subtotal amount field

If needed use another non numeric field to sort

after the display anyhow using the MENU options you can sort that subtotal field and see

Regards

Anji

Message was edited by:

Anji Reddy Vangala

Re: ALV - Sort Aggregation Column

Former Member — Wed, 21 Nov 2007 16:01:06 GMT

Hi Anji,

Nope, the menu option doesnt work. Subtotal disappear after sort. Is there a workaround for this?

Thanks.

Cady