Skip to Content
0
Former Member
Nov 02, 2010 at 08:08 PM

Text for Total and Subtotal rows in ALV

47 Views

Hello All

I wanted to show Text for Totals and Subtotals in ALV. I couldn't find any solution in old posts. Please help me in this

I have columns A B C the column C is having numeric field remaining fields are text fields. I am getting Totals and Subtotals by aggrtype_total and create_sort_rule(group_aggregation = abap_true), I applied sort_rule on both A and B fields for subtotals

 
A	B	C
Apples	Red	2
	Red	3
Apples	Red	5
Apples	Green	6
Apples	Green	6
Apples		11
Oranges	Grade1	6
	Grade1	6
Oranges	Grade2	8
	Grade2	3
	Grade2	11
Oranges		17
		28


I need in below format 

Apples	Red	2
	Red	3
Red Total		5
	Green	6
Green Total		6
Apples Total		11
Oranges	Grade1	6
Grade1 Total		6
Oranges	Grade2	8
	Grade2	3
Grade2 Total		11
Oranges Total		17
Total Fruits		28
 

My requirement is to provide only one text in the total row like u201CTotal Applesu201D and in the last row i need to provide text as "Grand Total" and grouping for column A

Please suggest me the possible way to achieve this.

Thanks,

Venkat.