Hello,
I've reviewed various discussions, but I am still having trouble getting a table to look like I need with sums/totals of different columns.
Here is the table I have.
PROCESS | MANAGER NAME | MANAGER ID | CHARGE | COUNT | AMOUNT |
L1 | V | A123456 | 13647 | 1 | -853.93 |
L1 | G | A124578 | 13647 | 1 | -52.32 |
L1 | C | A986532 | 13647 | 2 | -45213.9 |
L2 | H | A639096 | 13647 | 2 | -9763.77 |
H1 | H | A639096 | 23081 | 7 | -19308.82 |
UNIDENTIFIED | UNIDENTIFIED | UNIDENTIFIED | 13647 | 4 | -4686.27 |
UNIDENTIFIED | UNIDENTIFIED | UNIDENTIFIED | 23081 | 1 | 371.37 |
UNIDENTIFIED | UNIDENTIFIED | UNIDENTIFIED | 13647 | 1 | 1699.08 |
How I am wanting to have the table look.
PROCESS | MANAGER NAME | MANAGER ID | CHARGE | COUNT | AMOUNT |
L1 | V | A123456 | 13647 | 1 | -853.93 |
L1 | G | A123789 | 13647 | 1 | -52.32 |
L1 | C | A986532 | 13647 | 2 | -45213.9 |
L2 | H | A639096 | 13647 | 2 | -9763.77 |
H1 | H | A639096 | 23081 | 7 | -19308.82 |
UNIDENTIFIED | UNIDENTIFIED | UNIDENTIFIED | 13647 | 4 | -4686.27 |
UNIDENTIFIED | UNIDENTIFIED | UNIDENTIFIED | 23081 | 1 | 371.37 |
UNIDENTIFIED | UNIDENTIFIED | UNIDENTIFIED | 13647 | 1 | 1699.08 |
19 | -77808.56 |
Thanks.
Solved! Go to Solution.