I want to use org-mode as a (tea) database. What have I done:
1. I have wrote down a tree of shops/orders/brands 2. I defined COLUMNS for Column View that give me a score per shop list What do I want as result: 1. give me a list of scores for the shops [DONE] 2. give me a list of scores for each brand [TODO] is there a way to group together Tea brands to give each Brand a Score (how I liked it)? below are the data I used (the scores are just random test-data): (sorry the field names are german mostly) * Tea Database :PROPERTIES: :COLUMNS: %Shop(Shop) %Bewertung(Bewertung){mean} :END: ** Tee Kampagne :PROPERTIES: :Shop: Tee Kampagne :END: *** Bestellung 1 :PROPERTIES: :END: **** Tee 1 :PROPERTIES: :Sorte: Pussimbing :Bewertung: 1 :END: *** Bestellung 2 :PROPERTIES: :END: **** Tee 1 :PROPERTIES: :Sorte: Pussimbing :Bewertung: 5 :END: **** Tee 2 :PROPERTIES: :Sorte: Steinthal :Bewertung: 7 :END: ** Teeblätter Versand :PROPERTIES: :Shop: Teeblätter Versand :END: *** Tee 1 :PROPERTIES: :Sorte: Pussimbing :Bewertung: 6 :END: *** Tee 2 :PROPERTIES: :Sorte: Steinthal :Bewertung: 8 :END: *** Tee 3 :PROPERTIES: :Sorte: Risheehat :Bewertung: 9 :END: