From mboxrd@z Thu Jan  1 00:00:00 1970
From: Michael Brand <michael.ch.brand@gmail.com>
Subject: Re: sum up variables from different org-mode tables
Date: Mon, 19 Nov 2012 14:50:15 +0100
Message-ID: <CALn3zoggBA4XuECMkfhQjBodyfKpF8zd9UmY9Bo4pDPBuuqigg@mail.gmail.com>
References: <CAJkULmktbtUYOnZbhf_VLbhHoh8fiJca_6uOFK2qr7nDT0O+8Q@mail.gmail.com>
	<CALn3zoi4oyakLiKNshvqzmO8os6LySEaSPPn2Rg8x2L3Rrr80g@mail.gmail.com>
	<CAJkULmko4YdGDzHnceNe3OwSYcCky0rNMB3u3Nf+5aogDPaO9w@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([208.118.235.92]:35171)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1TaRju-0001pp-Uo
	for emacs-orgmode@gnu.org; Mon, 19 Nov 2012 08:50:21 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1TaRjr-0004xH-SC
	for emacs-orgmode@gnu.org; Mon, 19 Nov 2012 08:50:18 -0500
Received: from mail-vc0-f169.google.com ([209.85.220.169]:49591)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1TaRjr-0004xB-Ni
	for emacs-orgmode@gnu.org; Mon, 19 Nov 2012 08:50:15 -0500
Received: by mail-vc0-f169.google.com with SMTP id fl17so5950501vcb.0
	for <emacs-orgmode@gnu.org>; Mon, 19 Nov 2012 05:50:15 -0800 (PST)
In-Reply-To: <CAJkULmko4YdGDzHnceNe3OwSYcCky0rNMB3u3Nf+5aogDPaO9w@mail.gmail.com>
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: Martin Gross <m-gross@gmx.net>
Cc: Org Mode <emacs-orgmode@gnu.org>

Hi Martin

On Mon, Nov 19, 2012 at 12:54 PM, Martin Gross <m-gross@gmx.net> wrote:
> Just one point is not yet optimum to me: I do not have just 2 tables,
> but hundreds.  It would be hard and not very clean to add them all one
> by one.  Do you know if it there is a better way to reference remote
> tables?  For example telling org-mode to search data from all tables
> but "this" one?

I don=92t know a way to tell Org =93all other tables in this file=94.

And this:

On Fri, Nov 16, 2012 at 4:16 PM, Michael Brand
<michael.ch.brand@gmail.com> wrote:
>    A nice solution for variant 2 would be if
>    @2$3..@2$7 =3D remote(A, @>>$$#) :: @3$3..@3$7 =3D remote(B, @>>$$#)
>    could be simplified to
>    @I$3..@II$7 =3D remote($8, @>>$$#)

is only a partial solution for you because - although moved from the
formula to the result table - the table enumeration is still
necessary.

But if it=92s just summing up disjoint sets hierarchically you might
consider column view with =937.5.1.2 Column attributes=94 from the manual
to show the sums for each heading, like:

#+COLUMNS: %20ITEM %6In_num{+;%6d} %6In_EUR{+;%6.2f} %6Out_num{+;%6d}
%6Out_EUR{+;%6.2f}
* total
** Institution A
*** In
**** Title P
     :PROPERTIES:
     :In_num:   1
     :In_EUR:   45
     :END:
*** Out
**** Title A
     :PROPERTIES:
     :Out_num:   1
     :Out_EUR:   15
     :END:
**** Title B
     :PROPERTIES:
     :Out_num:   2
     :Out_EUR:   28
     :END:
** Institution B
*** In
**** Title Q
     :PROPERTIES:
     :In_num:   1
     :In_EUR:   24
     :END:
*** Out
**** Title C
     :PROPERTIES:
     :Out_num:   2
     :Out_EUR:   31
     :END:

Unfortunately formatting takes place only for calculations and not for
the raw source values which for me is at least a missing feature.

Michael