Transaction report to pivot table

[Kash]

On Tue, Feb 23, 2016 at 4:19 PM, Tommy Trussell <tommy.trussell at gmail.com>
wrote:

>
>
> 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.
>>
>
>
Hi Tommy, this helps a lot. Thanks you.