Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table, something like this;
LOAD * INLINE [ Date, Orderdate, Total 2018-08-10, 2018_29, 4 2018-09-24, 2018_33, 1
2018-09-26, 2018_34, 2 2018-10-12, 2018_36, 1 ];
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.
Thanks!
Is this always based on selection? If it is, then may be this
=Count({<Orderdate = P(Year_Week), Year_Week>} Total)