Things I have tried
I have this method of making a dataview list that’s sorted/grouped by a certain field which becomes unlinked headers in the list with the establishments nested underneath each District.
LIST WITHOUT ID
"**" + District + "**<br>" + join(rows.file.link, "<br>")
WHERE contains(file.folder, this.file.folder) AND location
GROUP BY District
Similarly I could also do a table of establishments but I don’t just want a District column of largely redundant information. I like how I can group the dataview list.
Table without id
District, file.link AS place, Type, Affiliation
WHERE contains(file.folder, this.file.folder) AND location
But attempt to group just results in empty rows
LIST WITHOUT ID
"**" + District + "**<br>" + join(rows.file.link, "<br>")
WHERE contains(file.folder, this.file.folder) AND location
GROUP BY District
so how do I actually group the rows?
What I’m trying to do
I want the table formatted like the list so instead of having a district column, I want the rows grouped into district clusters that are labeled by the district name. I don’t necessarily care whether the label is a dedicated row with the establishments nested below each one or if the District headers are off to the side.