Good Afternoon all, hopefully you may be able to help
I am trying to phase daily sales trends in particular months and days
For example in March i have 875 orders, there are 31 days in the month giving me a average of 62 orders a day. the bit i want to phase is that certain days of the week perform better. when i look at a week i see sales typically split as follows:
Sunday 16% of sales
Monday 16% Of Sales
Tuesday 11% of Sales
Wednesday 11% of Sales
Thursday 12% of Sales
Friday 19% of Sales
Saturday 15% of Sales
what formula could i add that would take the average daily figure for the month and then associate a uplift or decrease depending on what day of the week it is but still total 875 for the full month?
Thank you in advance for any assistance you may be able to give.
best Regards
Steve
I am trying to phase daily sales trends in particular months and days
For example in March i have 875 orders, there are 31 days in the month giving me a average of 62 orders a day. the bit i want to phase is that certain days of the week perform better. when i look at a week i see sales typically split as follows:
Sunday 16% of sales
Monday 16% Of Sales
Tuesday 11% of Sales
Wednesday 11% of Sales
Thursday 12% of Sales
Friday 19% of Sales
Saturday 15% of Sales
what formula could i add that would take the average daily figure for the month and then associate a uplift or decrease depending on what day of the week it is but still total 875 for the full month?
Thank you in advance for any assistance you may be able to give.
best Regards
Steve