Forum Discussion
Sub total in a Table with several columns
Hi LolHlde , hello selimovd, thank you for your prompt reply!
Use the matrix visual instead of the table visual, check the following steps:
- Add Contract Number ,title ,supplier and country to the Rows section, and add "Amount" to the Values section:
- Change the Layout to Tabular:
- Navigate to the Row subtotals setting, enable the subtotal for the first and second-level "Contract Number" and "Title," and turn off subtotals for other levels:
Result for your reference:
Best regards,
Joyce
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi LolHlde , hello selimovd, thank you for your prompt reply!
Use the matrix visual instead of the table visual, check the following steps:
- Add Contract Number ,title ,supplier and country to the Rows section, and add "Amount" to the Values section:
- Change the Layout to Tabular:
- Navigate to the Row subtotals setting, enable the subtotal for the first and second-level "Contract Number" and "Title," and turn off subtotals for other levels:
Result for your reference:
Best regards,
Joyce
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Anonymous ,
My data is retreieved from an oracle database. When I refresh, all the levels are "closed", and I see only the contract number. Is there a way to expand and open contract Number, Title, and supplier?