Dataview Table with Cross-Nested Groups:

[jeetsukumaran]

What I’m trying to do

I have a collection of notes with some metadata fields such as:

• planning-area
• planning-effort

The fields themselves are independent and not nested. So a given note can be in any combination of “planning-area” and “planning-effort” values.

I want to have an overview that shows me notes organized by planning effort, but with each area/note shown as their own row (sorted by effort/area/file), e.g…:

Effort	Area	File Link
A	a	note1
	b	note2
B	a	note3
	a	note4

Things I have tried

I can get the data to display, but it is structured incorrectly.

## T1

\```dataview
TABLE WITHOUT ID
   rows.Effort,
   Area,
   map(rows, (r) => r.rows.file.link) as File
WHERE planning-effort
GROUP BY planning-effort as Effort
GROUP BY rows.planning-area as Area
\```



## T2

\```dataview
TABLE WITHOUT ID
   planning-effort,
   rows.planning-area,
   rows.file.link
WHERE planning-effort
GROUP BY planning-effort
SORT planning-area
\```

It would also be really nice to actually group on the second field (planning-area), but I think that might be beyond what we can do easily.