on 11-02-2010 8:08 PM
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.
Hi Venkat,
I hope you would have solved this issue.
My requirement is also the same.
kindly help to solve.
In my alv list 6 columns are available.
1) Region
2)Section
3)Group
4)G/L account no
5) Amount
6)Currency key
I want to show
Total
Region Total
Inside region Total
Each section Total
Inside Each section total have
Each group total
Inside Each group total have
G/L account Total
Inside G/L account Total have
Different Currency key
In the total for sub groups and final total with out any text or Description getting only single or double or triple ( dots ) ..
Is it possible to populate / change with useful text or decription for those rows.
I am not getting Currency type after the total/sub totals.
how to fix this in ALV list after using aggregate for the ALV.
Thanks in advance.
Dav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.