Ok, I just found a way of doing it, maybe not the most pretty one but it does the job , well at least if I want to only see month or week.
Ideally I would like something that I can change the view from week to month without having to update parameters or create a separate sheet (hope it makes sense)
Average inventory_sol1.twbx 882.4 KB
If you create a Parameter with the values week and month you can just replace where you specify 'week' in your calculations and then switch between the two.
Thanks Joanna, it works like a charm.
It was so easy I didn't even think about it
I have the same problem and hoped to get it solved with your worksheet. unfortunately I cannot open the uploaded worksheet.
Any possibility that you upload your calculations again so I can follow Joanna's and your calculations?
All the best!