Related threads:
https://groups.google.com/forum/#!msg/beancount/S3lrphO-e2c/DIdxaUKBDgUJ
https://groups.google.com/forum/#!searchin/beancount/pivot$20select|sort:date/beancount/326EDC8cm7I/XNrBhNBgCgAJ
https://groups.google.com/forum/#!searchin/beancount/pivot$20select|sort:date/beancount/otu6I7NX5YQ/VLP7WbamEwAJ

Ticket:
https://bitbucket.org/blais/beancount/issues/61/implement-pivot-table-tool-make-sure-it

Recently I hashed out a Python script to prototype this to try to feel
whether the PIVOT BY idea would be sufficient.
Feel free to copy and modify to your own taste:
https://bitbucket.org/blais/beancount/src/tip/experiments/budget/monthly_expenses.py

I hope this helps,




On Sat, Oct 20, 2018 at 9:16 PM <[email protected]> wrote:

> Hi I recently converted 10+ years of quicken data into beancount and I am
> not looking back!
>
> One help needed is in bean-query... what is the best query to return
> columns as time periods? For example, months or years as columns and an
> account list or transaction list as rows?
>
> I can get this kind of report using Fava but I can't design a query to
> return it.  I have read that PIVOT BY might achieve this but it isn't
> available yet.
>
> Thanks alot for a great project!
>
> --
> You received this message because you are subscribed to the Google Groups
> "Beancount" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To post to this group, send email to [email protected].
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/beancount/30be3907-c5f3-4332-af0c-1d84c86bd3fd%40googlegroups.com
> .
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/beancount/CAK21%2BhMouXAujLPHrDBBg7pW4fKCR5HBDCdG15UYDqVnXe4ahA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to