Creating my own Summary (Stats) Table

Help needed:

I need to create custom summary reports.  I need to have the same information that a summary report is producing, but I need it in a table report format so I can use it with Juiced Docs.  Juiced lets me control other things on the doc - but the subtable can only pull in table formatted reports.

I have a Locations Table and a Locations Sales Table.  I need to be able to preset a date range on the locations table and have it return sales from the locations sales table as summary.

Ive been told - The answer lies in a "Stats table" - but I havent been able to get it setup properly

Example:

Jonies Pit Stop - Frosted Flakes - 10/2/22 - 3.19
Jonies Pit Stop - Frosted Flakes - 10/8/22 - 3.19
Jonies Pit Stop - Frosted Flakes - 10/28/22 - 3.19
Jonies Pit Stop - Lucky Charms - 10/5/22 - 3.09

I need the results to be 

Jonies Pit Stop 10/1/22 thru 10/08/22
Frosted Flakes - 2 - 6.38
Lucky Charms - 1 - 3.09
Totals                   3 - 9.47

------------------------------
Michael Knecht
------------------------------