Hi @johnward4 ,
Please try below query,
![index=businesstrans customer=*
| stats first(description) as description, sum(quantity) as quantity, first(unit_price) as unit_price by customer, _date, item_id
| stats list(item_id) as item_id, list(description) as Description, list(quantity) as quantity, list(unit_price) as unit_price, sum(eval(unit_price*quantity)) as Transaction_Total by customer, _date
| table _date, customer, item_id, Description, quantity, unit_price, Transaction_Total
| sort - Transaction_Total][1]
Hope this helps!
... View more