emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed

From: Michael Brand <michael.ch.brand@gmail.com>
To: Martin Gross <m-gross@gmx.net>
Cc: Org Mode <emacs-orgmode@gnu.org>
Subject: Re: sum up variables from different org-mode tables
Date: Mon, 19 Nov 2012 14:50:15 +0100	[thread overview]
Message-ID: <CALn3zoggBA4XuECMkfhQjBodyfKpF8zd9UmY9Bo4pDPBuuqigg@mail.gmail.com> (raw)
In-Reply-To: <CAJkULmko4YdGDzHnceNe3OwSYcCky0rNMB3u3Nf+5aogDPaO9w@mail.gmail.com>

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’t know a way to tell Org “all other tables in this file”.

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 = remote(A, @>>$$#) :: @3$3..@3$7 = remote(B, @>>$$#)
>    could be simplified to
>    @I$3..@II$7 = 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’s just summing up disjoint sets hierarchically you might
consider column view with “7.5.1.2 Column attributes” 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

next prev parent reply	other threads:[~2012-11-19 13:50 UTC|newest]

Thread overview: 9+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2012-11-16 11:33 sum up variables from different org-mode tables Martin Gross
2012-11-16 15:16 ` Michael Brand
2012-11-19 11:54   ` Martin Gross
2012-11-19 13:50     ` Michael Brand [this message]
2012-11-21 17:01       ` Martin Gross
2012-11-21 18:46         ` Suvayu Ali
2012-11-19 21:21     ` Eric Schulte
2012-11-22 10:03       ` Martin Gross
2014-01-04 15:29   ` Michael Brand

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

  List information: https://www.orgmode.org/

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=CALn3zoggBA4XuECMkfhQjBodyfKpF8zd9UmY9Bo4pDPBuuqigg@mail.gmail.com \
    --to=michael.ch.brand@gmail.com \
    --cc=emacs-orgmode@gnu.org \
    --cc=m-gross@gmx.net \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link

Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).