Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I use function day() to print only the number of my days. With set analysis I have 8 data. If my data are on two months I don't have the right sorting.
In dimension : I have : day(Date)
In measure : sum({< Date = {">=12/30/2020<=1/6/2021"}> } Prix)
I want order : 30/31/1/2/3/4/5/6 because 30 december is before 1st January ...
Thanks
Make your dimension
Dual(day(Date), Date)
and set your sorting to numeric.
-Rob