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.htmlHowever, I need help to understand how I can put the resulting sums inside the summary table.
Thanks,
Carl