The Orderdate is year_week-format. What I want is to select a month (from mastercalendar) and then in a textbox show the total number of orders that was made the weeks during the selected month.
So with the above data, selecting september would result in 1 order (2018_36), selecting august would result in 3 orders (2018_33 + 2018_34).
I know this is wrong but something like this;
=count({<Orderdate=Year_Week>} Total)
It rings a bell somwhere in the back of my head, but cant figure it out at the moment.