From mboxrd@z Thu Jan 1 00:00:00 1970 From: Cecil Westerhof Subject: Re: Sub-totals Date: Sat, 15 Feb 2014 18:14:57 +0100 Message-ID: References: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary=001a11c24edadbac1a04f2750fd0 Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:35828) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1WEipS-0005uN-Co for emacs-orgmode@gnu.org; Sat, 15 Feb 2014 12:15:03 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1WEipO-0006uj-KW for emacs-orgmode@gnu.org; Sat, 15 Feb 2014 12:15:02 -0500 Received: from mail-qa0-x234.google.com ([2607:f8b0:400d:c00::234]:58324) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1WEipO-0006uf-Ey for emacs-orgmode@gnu.org; Sat, 15 Feb 2014 12:14:58 -0500 Received: by mail-qa0-f52.google.com with SMTP id j15so19566884qaq.25 for ; Sat, 15 Feb 2014 09:14:58 -0800 (PST) In-Reply-To: List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-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 --001a11c24edadbac1a04f2750fd0 Content-Type: text/plain; charset=ISO-8859-1 2014-02-15 16:19 GMT+01:00 Michael Brand : > What about this?: > > |--------------+------+-----| > | activity | Time | sub | > |--------------+------+-----| > | Activity A | 3 | | > |--------------+------+-----| > | Activity B | 5 | 34 | > | Activity C | 2 | 34 | > | Activity D | 7 | 34 | > | Activity E | 8 | 34 | > | Activity F | 12 | 34 | > |--------------+------+-----| > | Activity 1 | 9 | 18 | > | Activity 2 | 2 | 18 | > | Activity 3 | 4 | 18 | > | Activity 4 | 3 | 18 | > |--------------+------+-----| > | Activity I | 23 | 111 | > | Activity II | 51 | 111 | > | Activity III | 37 | 111 | > |--------------+------+-----| > | | 163 | | > |--------------+------+-----| > #+TBLFM: @>$2 = vsum(@<<<..@>>) :: @<<<$3..@>>$3 = vsum(@-I$2..@+I$2) > It is certainly a big step in the right direction. I have to study it to understand what it does. (You also changed the part I already had. I have to look to see why that is better.) There are a few problems with it: - As your example shows, the first element is not filled and when the first range only has one element ... - I would like to have only the last element of the range filled. But it is certainly helpful: thanks. -- Cecil Westerhof --001a11c24edadbac1a04f2750fd0 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
2014= -02-15 16:19 GMT+01:00 Michael Brand <michael.ch.brand@gmail.com<= /a>>:
What about this?:

|--------------+------+-----|
| activity     | Time | sub |
|--------------+------+-----|
| Activity A   |    3 |     |
|--------------+------+-----|
| Activity B   |    5 |  34 |
| Activity C   |    2 |  34 |
| Activity D   |    7 |  34 |
| Activity E   |    8 |  34 |
| Activity F   |   12 |  34 |
|--------------+------+-----|
| Activity 1   |    9 |  18 |
| Activity 2   |    2 |  18 |
| Activity 3   |    4 |  18 |
| Activity 4   |    3 |  18 |
|--------------+------+-----|
| Activity I   |   23 | 111 |
| Activity II  |   51 | 111 |
| Activity III |   37 | 111 |
|--------------+------+-----|
|              |  163 |   &nbs= p; |
|--------------+------+-----|
#+TBLFM: @>$2 =3D vsum(@<<<..@>>) :: @<<<$= 3..@>>$3 =3D vsum(@-I$2..@+I$2)

It is certainly a big step in the right direction. I have to study it to un= derstand what it does. (You also changed the part I already had. I have to = look to see why that is better.)

There are a few problems with it:
- As your example shows, the first= element is not filled and when the first range only has one element &helli= p;
- I would like to have only the last element of the range filled.
But it is certainly helpful: thanks.

--
Cecil Westerhof
--001a11c24edadbac1a04f2750fd0--