Color top 5 in a straight table with 2 dimensions

[#1]

Dear all,

I want to create a straight table with all observations. The first 5 observations should be coloured based on 5 highest values.

this is the screenshot:

When I have defined only one dimension in the table, then everything works fine.

However, not for two dimensions.

In addition, the table is not correctly sorted.

Do you see any solution?

Thanks and best regards,

Cornelis.

[sunny_talwar · Accepted solution]

Try this expression:

=IF(RANK(TOTAL sum(value)) < 6, yellow())

[#3]

Dear Sunny,

Yes, that is the solution.

it is a good learning point. TOTAL is important to rank, not SUM only.

Excellent!

Best regards,

Cornelis