I would like to have the abilty to be able to see the individual spend categories against an invoice where there are more than one line and category used. This will allow the specific spend per category to be seen within the extracted .csv file.

Current Output csv seems to have been constructed with Sum(Amount) as Total, String_Agg(Category, ",") as Category where Date between @start_dte and @end_dte Group By TransactionID ....... I need to have the group by removed and see the line item details including indiviudal category spend