(Last updated on: May 11, 2017)
Want to drill deep to see a week by week comparison of sales totals? You can do it easily by modifying the query in the Export email function.
Go to Mailing list | Generate a mailing list | Export email, then click on the Edit the query tab. Copy and paste the codes below, then click Export list.
select weekofyear(today_date) as Month, sum(total_tix) as Tix, sum(total_sale) as Sales from mainsale group by weekofyear(today_date);
Here is a sample of the report:
