Transaction report to pivot table

[Tommy Trussell]

On Tue, Feb 23, 2016 at 3:25 PM, Kash <melbogia at gmail.com> wrote:

> I am trying to export the transaction report to libreoffice so I can use
> pivot tables on the report. When I import it the spreadsheet looks like
> this http://pastebin.com/raw/irdZJPug, which doesn't really work with
> pivot
> tables. I can remove the "Total For Adjustment", "Total For Auto", and
> "Total For Gas" rows before I export but the real problem is that I'd need
> the rows "Adjustment", "Auto", "Gas" in a column by itself for pivot tables
> to work. How can I do that? I assume I need to have the transaction report
> in gnucash in a certain way for that to happen. I'd rather not have to
> manually edit the spreadsheet after export.
>
>
How about if you go to the Transaction Report settings, and

  on the Display tab, turn ON Account Name, and
  on the Sorting tab,
     Primary Key: Account name,
     Primary Subtotal off (un-checked)
     and Secondary Key: None.

Does that get you closer to what you need?



> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>