Forum Discussion
Show Total on Row Header even if expanded.
I have the following Matrix that shows the following when the Row Header has been collapsed:
However, when expanding the Row Header to show the items below "Marketable Equity",
how can I show the subtotals for the Row Header "Marketable Equity"?
Thank you.
In the format pane for the Matrix, open Row subtotals and make sure it is on. If "Per row level" is also on, you need to switch on the toggle for the specific row level that contains Marketable Equity, otherwise the subtotal stays hidden when that level is expanded. Once enabled, the Marketable Equity row will display its total even with its children showing, and the Position setting controls whether it appears above or below them.
If this helped, a thumbs up and accepting the solution would be appreciated.
Best,
Shai Karmani
2 Replies
In the format pane for the Matrix, open Row subtotals and make sure it is on. If "Per row level" is also on, you need to switch on the toggle for the specific row level that contains Marketable Equity, otherwise the subtotal stays hidden when that level is expanded. Once enabled, the Marketable Equity row will display its total even with its children showing, and the Position setting controls whether it appears above or below them.
If this helped, a thumbs up and accepting the solution would be appreciated.
Best,
Shai KarmaniThank Shai_Karmani . I was hoping it was as simple as that. Thank you again.
