Forum Discussion
buttercream
Helper II
Helper IIUnable to subtotal on first column for matrix visual
Hi,
I'm trying to achieve this table. I've set the subtotal per row to show for customer only but it's not showing at all.
What I'm getting
| Customer | Name | Product | Invoice | Amount |
| 110 | ABC | Apple | 7867 | 800 |
| Apple | 5832 | 700 | ||
| Apple | 6200 | 100 | ||
| Banana | 8371 | 600 | ||
| 210 | BYX | Pear | 9753 | 100 |
| Strawberries | 4170 | 400 | ||
| Total | 2700 |
What I'm trying to accomplish
| Customer | Name | Product | Invoice | Amount |
| 110 | ABC | Apple | 7867 | 800 |
| Apple | 5832 | 700 | ||
| Apple | 6200 | 100 | ||
| Banana | 8371 | 600 | ||
| Total 110 | 2200 | |||
| 210 | BYX | Pear | 9753 | 100 |
| Strawberries | 4170 | 400 | ||
| Total 210 | 500 |
why would you add up invoice numbers?
You may want to consider a matrix visual, not a table visual
Or with selective subtotals
2 Replies
- lbendlin
Super User
why would you add up invoice numbers?
You may want to consider a matrix visual, not a table visual
Or with selective subtotals
- Kedar_Pande
Format pane → Row subtotals → Per row level ON → Toggle Customer ON, Name/Product/Invoice OFF.
Subtotals show only under Customer column.
