How to create Custom Item Sales Report by Ticket Type?

Hello everyone,

I’ve been trying to create a custom sales report by ticket type but I can’t make it to show Quantity and Total columns (like the default “Item Sales Report”).

First “Sales” table is the default sales that I copy from “Item Sales Report”.

I use ticket “Ticket-FC06310” for Cho Dem department and “Ticket-FC06311” for Nha Den department.

It works fine except for showing quantity and total column. I’ve tried several times in different methods but something went wrong and my table just disappeared. Can you show me how to do it? I’m new to this custom report and coding stuff :smile:

Thanks in advance.

I found out how to do it here: Custom Report - How to ticket seperated Item Sales Report by Ticket Type?