Does anyone have some sort of Weekly by hour report What i would like to see is a whole week day by day and total sales for each hour.
09:00 M T W T F S S
10:00 X X
11:00 X X
Thanks for help
Robert
09:00 M T W T F S S
10:00 X X
11:00 X X
Weekly by hour report
Sep 18, 2009
3 Replies
09:00 M T W T F S S
10:00 X X
11:00 X X
Hi Robert
We have a report that will give you exactly that. This report is available > Does anyone have some sort of Weekly by hour report
You can do this with a query and then run a pivot table in excel:
select left(time,12) date, right(left(time,14),2)+':00 '+right(left(time,19),2) hour, sum(quantity*price) total from [transacti> Does anyone have some sort of Weekly by hour report
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required