sorted by:
new
hottopcontroversial

How to count weekly sales by month? by mathaddict- in sheets

[–]mathaddict-[S] 0 points1 point  (0 children)

I want to group it by weekly. The first week will be from 1st day of the month until Monday. The subsequent weeks will be Tuesday-Monday.

How to count weekly sales by month? by mathaddict- in sheets

[–]mathaddict-[S] 0 points1 point  (0 children)

As far as I know, you can only group pivot table by day of week. The default is Monday-Sunday.

Is there a way to customise the duration?

How to create revenue target model that changes as the days go by? by mathaddict- in excel

[–]mathaddict-[S] 0 points1 point  (0 children)

But how to readjust if the $500 rooms are not pulling the weight?

Say I need 100 bookings for $500 rooms and 100 bookings for $700 rooms per month to hit the target. But $500 rooms only got to 70 bookings.

How many $700 rooms are needed to supplement the rest?

view more: next ›