From mboxrd@z Thu Jan 1 00:00:00 1970 From: Michael Brand Subject: Re: Sub-totals Date: Sat, 15 Feb 2014 16:19:09 +0100 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:45252) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1WEh1L-0007xU-NB for emacs-orgmode@gnu.org; Sat, 15 Feb 2014 10:19:12 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1WEh1K-0006VM-S9 for emacs-orgmode@gnu.org; Sat, 15 Feb 2014 10:19:11 -0500 Received: from mail-qc0-x22f.google.com ([2607:f8b0:400d:c01::22f]:35994) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1WEh1K-0006UP-IL for emacs-orgmode@gnu.org; Sat, 15 Feb 2014 10:19:10 -0500 Received: by mail-qc0-f175.google.com with SMTP id x13so21478141qcv.20 for ; Sat, 15 Feb 2014 07:19:09 -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: Cecil Westerhof Cc: Org Mode Hi Cecil 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) Michael