From mboxrd@z Thu Jan  1 00:00:00 1970
From: Stefan Huchler <stefan.huchler@mail.de>
Subject: how to group together fields
Date: Thu, 30 Jan 2014 16:45:47 +0100
Message-ID: <87fvo5tqvo.fsf@mars.lan>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:58170)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1W8vkk-0000t3-7b
	for emacs-orgmode@gnu.org; Thu, 30 Jan 2014 12:50:21 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1W8vkc-0000wx-UH
	for emacs-orgmode@gnu.org; Thu, 30 Jan 2014 12:50:14 -0500
Received: from plane.gmane.org ([80.91.229.3]:45351)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1W8vkc-0000vH-Hv
	for emacs-orgmode@gnu.org; Thu, 30 Jan 2014 12:50:06 -0500
Received: from list by plane.gmane.org with local (Exim 4.69)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1W8vka-00022Q-T9
	for emacs-orgmode@gnu.org; Thu, 30 Jan 2014 18:50:04 +0100
Received: from hsi-kbw-109-193-109-175.hsi7.kabel-badenwuerttemberg.de
	([109.193.109.175])
	by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Thu, 30 Jan 2014 18:50:04 +0100
Received: from stefan.huchler by
	hsi-kbw-109-193-109-175.hsi7.kabel-badenwuerttemberg.de with
	local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Thu, 30 Jan 2014 18:50:04 +0100
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: emacs-orgmode@gnu.org

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: