Forum Discussion
Two row headers without stepped layout
You can control row subtotals for each field. That allows you to keep the row total but suppress all subtotals, for example.
Thanks, I now switched on the "Apply settings to: Per row level"
I don't know, why I haven't figured that out earlier, because before I wrote this thread, I have clicked around everywhere in the settings. 🤔
And I don't understand why the option "Per row level: on" causes it to let the subtotals disappear, but the main thing is that it works.
Yet another problem:
I cannot sort by the second row header (CompanyName). It is only sorted in the context of the first row header (CompanyNumber). Since I always have exactly one CompanyName for a CompanyNumber it makes no sense. Again: I don't want to use a normal table, because I want the "Pivot Table like" feature with dynamic columns and so on.
Is my use case so special? I don't understand why it is so complicated.
Use "sort one column by another column" and sort company number by company name