Historical sales data by year

Want to see a quick report of yearly sales figures and trends?

Go to Mailing list | Generate a mailing list | Export email, then click on the Edit the query tab. Copy and paste the code below, then click Export list.

select year(today_date) as Year, lpad( format(sum(total_tix),0),6, ‘ ‘) as Tix, lpad(format(sum(total_sale),2),13, ‘ ‘) as Sales from oldsales group by year(today_date) order by today_date;

Here is a sample of what the report looks like:

by year

OR: Hop on overĀ  to the new Historical Report.

You can get the same data by year, month or week!

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

Leave a Reply