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:
OR: Hop on over to the new Historical Report.
You can get the same data by year, month or week!