Need to show top 3 color coding

[bharatkishore]

Hi All,

I have an  straight table chart. I have an expression like (sum([Unique Opens])/sum([Total Sends]-([Total Bouncebacks])))

You can see the values as in the attached image:

Now my requirement i need to show i mean highlight the values in green color which are top 3. I need to show it with an indicator.

Kindly help.

[Anil_Babu_Samineni]

Bharat Kishore wrote:

Not top 3. I need to show only top 3 in green color else no color.

What is the mean of that?

[adamdavi3s]

You don't seem to have tried to implement my solution at all?

My solution will work, simply exclude the other colours from the ranking

[bharatkishore]

Sorry typo my mistake..I need to show top 3 numbers in green color for respective market and brand.

for example: I have

1

4

5

7

6

9

Now  9,6,7, should be in green color...remaining values no color in indicator symbol..

[adamdavi3s]

So this is a new requirement to the original one?

I have no problem trying to help but this is getting a little confusing now

[bharatkishore]

Hi Adam,

I have tried your solution as well.

But please see the attached image: here also i can see you can see highlighting only two are in green color. I Need top 3.

[bharatkishore]

No no.. this is of yesterday requirement..

[adamdavi3s]

There is something really weird going on with your chart and the way it is displaying. It's not showing all values and I can't spot why but there must be something obvious

I created a new one and it works fine, see bottom right table:

[bharatkishore]

Yes i needed exactly the same way.. can u pls help how can i get that one..

N what expression i need to add..

[sudeepkm]

I agree with Adam Davies. Please check your data it seems something is not right some sort or redundant data might be causing issue. anyways I did a rank total and then a sorting on the rank and found the solution the way you want. please take a look.

[adamdavi3s]

I did nothing other than what I showed in my example above.

I don't think its a data issue but something in your table is really screwy!