From mboxrd@z Thu Jan  1 00:00:00 1970
From: Cecil Westerhof <cldwesterhof@gmail.com>
Subject: Sub-totals
Date: Sat, 15 Feb 2014 15:27:49 +0100
Message-ID: <CAG-LmmC4-3f8UN+vQn3Hg7vAc51Qsv2m-L4or8DN0ZdmmoYB+Q@mail.gmail.com>
Mime-Version: 1.0
Content-Type: multipart/alternative; boundary=001a11c24eda1f0c0904f272babb
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:38091)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <cldwesterhof@gmail.com>) id 1WEgDf-0007ea-NP
	for emacs-orgmode@gnu.org; Sat, 15 Feb 2014 09:27:52 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <cldwesterhof@gmail.com>) id 1WEgDe-0001AO-Fn
	for emacs-orgmode@gnu.org; Sat, 15 Feb 2014 09:27:51 -0500
Received: from mail-qa0-x235.google.com ([2607:f8b0:400d:c00::235]:39248)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <cldwesterhof@gmail.com>) id 1WEgDe-0001AE-9y
	for emacs-orgmode@gnu.org; Sat, 15 Feb 2014 09:27:50 -0500
Received: by mail-qa0-f53.google.com with SMTP id cm18so19448819qab.26
	for <emacs-orgmode@gnu.org>; Sat, 15 Feb 2014 06:27:49 -0800 (PST)
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

--001a11c24eda1f0c0904f272babb
Content-Type: text/plain; charset=ISO-8859-1

At the moment I have the folowing:
|--------------+------+-----|
| activity     | Time | sub |
|--------------+------+-----|
| Activity A   |    3 |     |
| Activity B   |    5 |     |
| Activity C   |    2 |     |
| Activity D   |    7 |     |
| Activity E   |    8 |     |
| Activity F   |   12 |     |
|--------------+------+-----|
| Activity 1   |    9 |     |
| Activity 2   |    2 |     |
| Activity 3   |    4 |     |
| Activity 4   |    3 |     |
|--------------+------+-----|
| Activity I   |   23 |     |
| Activity II  |   51 |     |
| Activity III |   37 |     |
|--------------+------+-----|
|              |  163 |     |
|--------------+------+-----|
#+TBLFM: @>$2=vsum(@3..@-1)


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

Subtotals from every range is calculated. Preferable from second to second
last, so it goes OK when a range is added.

Is this possible?

-- 
Cecil Westerhof

--001a11c24eda1f0c0904f272babb
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_default" style=3D"font-family:courier =
new,monospace">At the moment I have the folowing:<br clear=3D"all"></div><d=
iv class=3D"gmail_default" style=3D"font-family:courier new,monospace;displ=
ay:inline">
|--------------+------+-----|<br>| activity=A0=A0=A0=A0 | Time | sub |<br>|=
--------------+------+-----|<br>| Activity A=A0=A0 |=A0=A0=A0 3 |=A0=A0=A0=
=A0 |<br>| Activity B=A0=A0 |=A0=A0=A0 5 |=A0=A0=A0=A0 |<br>| Activity C=A0=
=A0 |=A0=A0=A0 2 |=A0=A0=A0=A0 |<br>| Activity D=A0=A0 |=A0=A0=A0 7 |=A0=A0=
=A0=A0 |<br>
| Activity E=A0=A0 |=A0=A0=A0 8 |=A0=A0=A0=A0 |<br>| Activity F=A0=A0 |=A0=
=A0 12 |=A0 =A0=A0 |<br>|--------------+------+-----|<br>| Activity 1=A0=A0=
 |=A0=A0=A0 9 |=A0=A0=A0=A0 |<br>| Activity 2=A0=A0 |=A0=A0=A0 2 |=A0=A0=A0=
=A0 |<br>| Activity 3=A0=A0 |=A0=A0=A0 4 |=A0=A0=A0=A0 |<br>| Activity 4=A0=
=A0 |=A0=A0=A0 3 |=A0 =A0=A0 |<br>
|--------------+------+-----|<br>| Activity I=A0=A0 |=A0=A0 23 |=A0=A0=A0=
=A0 |<br>| Activity II=A0 |=A0=A0 51 |=A0=A0=A0=A0 |<br>| Activity III |=A0=
=A0 37 | =A0 =A0 |<br>|--------------+------+-----|<br>|=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0 |=A0 163 |=A0=A0=A0=A0 |<br>|--------------+------+--=
---|<br>
#+TBLFM: @&gt;$2=3Dvsum(@3..@-1)<br></div><br><div class=3D"gmail_default" =
style=3D"font-family:courier new,monospace;display:inline">But I want the f=
ollowing:<br>|--------------+------+-----|<br>| activity=A0=A0=A0=A0 | Time=
 | sub |<br>
|--------------+------+-----|<br>| Activity A=A0=A0 |=A0=A0=A0 3 |=A0=A0=A0=
=A0 |<br>| Activity B=A0=A0 |=A0=A0=A0 5 |=A0=A0=A0=A0 |<br>| Activity C=A0=
=A0 |=A0=A0=A0 2 |=A0=A0=A0=A0 |<br>| Activity D=A0=A0 |=A0=A0=A0 7 |=A0=A0=
=A0=A0 |<br>| Activity E=A0=A0 |=A0=A0=A0 8 |=A0=A0=A0=A0 |<br>| Activity F=
=A0=A0 |=A0=A0 12 |=A0 34 |<br>
|--------------+------+-----|<br>| Activity 1=A0=A0 |=A0=A0=A0 9 |=A0=A0=A0=
=A0 |<br>| Activity 2=A0=A0 |=A0=A0=A0 2 |=A0=A0=A0=A0 |<br>| Activity 3=A0=
=A0 |=A0=A0=A0 4 |=A0=A0=A0=A0 |<br>| Activity 4=A0=A0 |=A0=A0=A0 3 |=A0 18=
 |<br>|--------------+------+-----|<br>| Activity I=A0=A0 |=A0=A0 23 |=A0=
=A0=A0=A0 |<br>
| Activity II=A0 |=A0=A0 51 |=A0=A0=A0=A0 |<br>| Activity III |=A0=A0 37 | =
111 |<br>|--------------+------+-----|<br>|=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0 |=A0 163 |=A0=A0=A0=A0 |<br>|--------------+------+-----|<br>#+TB=
LFM: @&gt;$2=3Dvsum(@3..@-1)<br><br></div><div class=3D"gmail_default" styl=
e=3D"font-family:courier new,monospace;display:inline">
Subtotals from every range is calculated. Preferable from second to second =
last, so it goes OK when a range is added.<br></div><div class=3D"gmail_def=
ault" style=3D"font-family:courier new,monospace;display:inline"><br></div>
<div class=3D"gmail_default" style=3D"font-family:courier new,monospace;dis=
play:inline">Is this possible?</div><br>-- <br>Cecil Westerhof
</div>

--001a11c24eda1f0c0904f272babb--