Detailed Item Report with Statistics Day, MTD and Year with Totals at the Bottom

We have items in our retail that have been created in SNT.  How do I run a report that shows all the Items and the Revenue Generated Daily, MTD and YTD?  I ran a transaction report, but that show the Charge Group and not down the the individual item.  I am looking to find out how many specific beers we have sold, etc... Not just the Charge Group Beer.  Please advise.