What I’m trying to do
I am trying to create a dataview table which groups my notes based on the topics they cover and then groups them by Subject they are related to so that I can have a through visualisation.
Structure of my notes in the Vault
Every subject note is tagged as #sub, topic as #topic and note as #note. Topic notes have a metadata Subject:: [[Name of the subject]] and then every note has a metadata Topic::[[Name of the topic]].
Things I have tried
Problem
As you can see the topic column does render the names of the topics but they are clubbed together and there is not distinction between which note is related to which topic. (though subject distinction is clear).
Required Result should look like this
