Hi SAP Experts,
Currently I have ALV Grid table as below as example :
FIELD1 | FIELD2 | Account | Amount |
-
1. Rev | 1.Rev | Acct1 | 100.00 |
1. Rev | 1.Rev | Acct2 | 50.00 |
-
Subtotal FIELD2 (1.Rev) | 150.00 |
Subtotal FIELD1 (1.Rev) | 150.00 |
-
2. Cost | 2.1 Cost1 | Acct3 | 100.00 |
2. Cost | 2.1 Cost1 | Acct4 | 75.00 |
-
Subtotal FIELD2 (2.1 Cost1) | 175.00 |
-
2. Cost | 2.2 Cost2 | Acct5 | 25.00 |
-
Subtotal FIELD2 (2.2 Cost 2) | 25.00 |
-
| Subtotal FIELD1 (2.Cost) | 200.00 |
-
I have 2 questions.
First, as you can see, I have 2 subtotal for 1.Rev eventhough 1.Rev actually only need one subtotal because there is no subgroup for 1.Rev. Is it possible to have only one subtotal for this 1.Rev but I still maintained 2 subtotal for 2.Cost because 2.Cost has subgroup?
My 2nd issue is I need to insert another row exactly below Subtotal FIELD1 (2.Cost) row like this:
-
Gross Margin | (Some formula) |
-
This row does not come from any sub total. The problem is I can not just insert this column and put Gross Margin description in FIELD1 because I will have 3 row like below :
-
-
Subtotal FIELD2 (blank) | (Formula) sub total |
Subtotal FIELD1 (Gross Margin) | (Formula) sub total |
-
Is there any way I can insert Gross Margin Row without creating new subtotal for it so it will only have one line in the ALV Grid table? Please help. Thank you.
Regards,
Abraham
Bluesky
