I have a pivot table with a final grand total. But I’m woindering how to get a row total for each customer.
example data:
| Customer | Type | Num | Day | Month | Sum - Net Total | Sum - VAT | Sum - Total |
|---|---|---|---|---|---|---|---|
| TEST | Inv | 24164 | 01 | 09 | 3,752.00 | 750.40 | 4,502.40 |
| 24215 | 26 | 09 | 113.00 | 22.60 | 135.60 | ||
| 24228 | 03 | 10 | 870.00 | 174.00 | 1,044.00 | ||
| TEST2 | Inv | 24216 | 26 | 09 | 259.70 | 51.94 | 311.64 |
Row1 should say total for customer TEST = 5682
Row2 should say total for customer TEST2 = 311.64
The totals are already done in the pivot so not sure how to add an extra per row total