Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
When I select for example the month of january 2019, I want to get only the last value of that month, in the example below, it should show me 31-01-2020 and the value 30.
I tried with Max(VisitDate) but it didn't work.
you can use
=Date(Monthend(VisitDate))
Your formula didn't work. I used instead
max(aggr(count({< PDV_ModelName={'Available on EXIT'},PDV_Boolean={1},StoreDisabled={0}>} ProductId&StoreId),StoreId, VisitDate))
It gives me the correct last value of each store if I select for example the month of january 2019, but the total is incorrect.