I am trying to create subgroups for rows in a table similar to the layout of pivot tables in Excel (see screenshot)
At the moment I am using the following code below to create a flat table with dataviewjs. Does anyone of you know of a way to insert subgroups into this flat table, similar to the attached screenshot.
However, the groups are not collapsible, and you’re not totally safe that the groups are corresponding inbetween their list items. In most cases, it should be alright though.
You could, if you really need to collapse stuff, exchange the dv.table() call with a list traversing where you output the key as a header, and present the other values in a table under that header. (However, there is an issue with dataview not allowing headers to be collapsed when output by dataviewjs, so then we’re back to square one)