emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
* Sub-totals
@ 2014-02-15 14:27 Cecil Westerhof
  2014-02-15 15:19 ` Sub-totals Michael Brand
  0 siblings, 1 reply; 9+ messages in thread
From: Cecil Westerhof @ 2014-02-15 14:27 UTC (permalink / raw)
  To: emacs-orgmode

[-- Attachment #1: Type: text/plain, Size: 1538 bytes --]

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

[-- Attachment #2: Type: text/html, Size: 2277 bytes --]

^ permalink raw reply	[flat|nested] 9+ messages in thread

end of thread, other threads:[~2014-02-20  7:56 UTC | newest]

Thread overview: 9+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2014-02-15 14:27 Sub-totals Cecil Westerhof
2014-02-15 15:19 ` Sub-totals Michael Brand
2014-02-15 17:14   ` Sub-totals Cecil Westerhof
2014-02-15 17:31     ` Sub-totals Cecil Westerhof
2014-02-16  9:06     ` Sub-totals Michael Brand
2014-02-19  5:00       ` Sub-totals Cecil Westerhof
2014-02-19 12:54         ` Sub-totals Nick Dokos
2014-02-19 19:39           ` Sub-totals Michael Brand
2014-02-20  7:55       ` Sub-totals Michael Brand

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).