Sales Amount and Sold Quantity By Hour Grouped By Item Name

My Question is:
I need to create one report for Items to show the sales amount and one to show the sold qty for grouped by item name during the working hours.

As example in pic:


So can you please tell me how to do???

EX:
Items Sold Qty
Item name 08-09 09-10 10-11 11-12 12-13 etc
(Item1) 2 0 1 5 1
(Item2) 0 1 2 3 4
etc

Item Sales
Item name 08-09 09-10 10-11 11-12 12-13 etc
(Item1) 35 0 17.5 87.5 17.5
(Item2) 0 20 40 60 80
etc

Thanks in advance

1 Like

@QMcKay I know this post but it is not what I’m asking. This post is for sales by hour, I’m talking about View by item name not total number. I need total by item tracing by hour.
As following as example: