Forum Discussion
Inserting Subtotals in a Table
Use a Matrix but make it look like a Table
Put your detail fields (Customer, Document No., Line, Item, …) in the Matrix Rows
Put Total_Sales in Values
Put Location as the first row level (above the details)
Turn on Subtotals for Location
Then format it to look like a Table:
Row headers: Stepped layout = Off
Subtotals: On (only for Location)
Gridlines / outline: adjust to match your table style
I would add to the steps that cengizhanarslan suggestes to use the Outline or Tabular formatting in the matrix visual. This was the game changer for our team. This is under the format pane:
Hi Principiante,
I would also take a moment to thank cengizhanarslan , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Regards,
Community Support Team.
Hi Principiante,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.
Regards,
Community Support Team.