emacs-orgmode
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[O] monthly budget with year summary using tables


From: Carl Bolduc
Subject: [O] monthly budget with year summary using tables
Date: Wed, 2 Jan 2013 14:21:12 -0500

I would like to move my budget from MS Excel to Org-Mode. I currently have one Excel sheet per month with all the transactions as well as a summary sheet that uses sumif functions.

Assuming the following format for the monthly table:

#+tblname: january
| date | transaction | amount | category  |
|------+-------------+--------+-----------|
|   01 | iga         |     50 | groceries |
|   01 | echo        |     30 | car       |
|   02 | iga         |     47 | groceries |

How can I get the following summary table?

| category  | january | february |
|-----------+---------+----------|
| groceries |      97 |          |
| car       |      30 |          |
 
I found this post on the mailing list that suggest to use babel:
http://www.mail-archive.com/emacs-orgmode@gnu.org/msg22736.html

However, I need help to understand how I can put the resulting sums inside the summary table.

Thanks,
Carl

reply via email to

[Prev in Thread] Current Thread [Next in Thread]