Please assist with a Rank formular

[Ditshele]

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

[rubenmarin · Accepted solution]

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