How to create a zip code report for sales in a specific date range

(Last updated on: December 13, 2018)

  • Go to Reports | Other reports | Export email.  This is what to put in for the query:

select
    sum(total_tix) as tickets, sum(total_sale) as sales, left(zip,5) as zip
from mainsale
left join customer using(customer_id)
where today_date >= "201x-xx-xx"
    and today_date <= "201x-xx-xx"
group by left(zip,5)
order by zip

  • This is what it looks like:

  • When the report is run and sent to a spreadsheet, the report looks like this:

 

 

 

This entry was posted in Desktop Software, Reports, Wintix5 and tagged . Bookmark the permalink.

Leave a Reply