Rank based on each month
Hi Angelina_QBeeQ , I want to set the rank independently for each month based on measure. Rank logic: RANK([Overall Vol],"1224",[l3_demand],[Months in contact_date]) As per below sc, rank shd be 1...
Forum Discussion
Hi Tulu,
In some versions, the rank function does not work properly when you need to group by option. What you can try:
- Write in rank "rank type" (1234,1224 etc) first and then asc/desc. I saw this issue in version L2023.2.
-Try turning off the analytical engine and check the rank again.It may take some time for the changes to be applied.
- Discuss the case with Sisense support.
- Make a custom table for your needs in the EC.
Kind Regards,
Angelina
