Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day
Please assist with an expression to show 100 Cost Centres with the lowest Score and Highest number of customer for each quarter.
I am not familiar with the Rank function,i don't even know where to start.
My grid should show a Cost centre and quarters(1-4) on top,If a CC falls within the category 'Yes' if not 'No'
CC Q1 Q2 Q3 Q4
321 Yes No Yes Yes
003 No Yes No No
004 Yes No Yes Yes
Hi @Ditshele, you can use an expression like: If(Rank(Sum(Value),1,1)=1, 'Yes','No') to set Yes to the higher. Or If(Rank(-Sum(Value),1,1)=1, 'Yes','No') to set Yes to the lower
Hi @Ditshele, you can use an expression like: If(Rank(Sum(Value),1,1)=1, 'Yes','No') to set Yes to the higher. Or If(Rank(-Sum(Value),1,1)=1, 'Yes','No') to set Yes to the lower