S
swas
Hi,
I want to create a query that returns total sales grouped on a weekly basis.
This isn't hard for monthly by just grouping on the month.
Ideally I want to define what constitutes the week (Mon - Sun, or Thu - Wed
etc...) and then return total daily sales for each.
With no 'week' style function I can't get my head around a simple solution,
without making up a bunch of seperate queries defining each week.
Thanks in advance.
swas
I want to create a query that returns total sales grouped on a weekly basis.
This isn't hard for monthly by just grouping on the month.
Ideally I want to define what constitutes the week (Mon - Sun, or Thu - Wed
etc...) and then return total daily sales for each.
With no 'week' style function I can't get my head around a simple solution,
without making up a bunch of seperate queries defining each week.
Thanks in advance.
swas