[O] how to group together fields

[Stefan Huchler]

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: