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.