Highlighting the highest values in a column?

[rohitians]

Dear All,

I have a requirement where in i need to highlight the highest values in a column,

is it possible ??

kindly help

DIVN	Month	Gross Sales	Credit Note	Net Sales	Free Issues	WEST	SOUTH	NORTH	EAST
TOTAL		32,328	990	31,327	3,212	34	34.1	16.9	15.1
XYZ	TOTAL
	Total	4,620	100	4,518	574	35.3	31.7	17	16.1
	Apr	1,548	38	1,510	191	37.7	29.7	16.1	16.5
	May	1,462	32	1,429	180	34.7	31.1	18.6	15.6
	Jun	1,610	30	1,579	204	33.5	34.1	16.3	16.2
	Total	5,379	131	5,246	696	38.8	31.1	15.8	14.3
	Jul	1,658	48	1,609	214	35.4	33.6	16.7	14.3
	Aug	1,797	44	1,753	231	39.4	30.5	15.9	14.1
	Sep	1,925	39	1,885	250	41	29.6	14.9	14.4
	Total	1,927	64	1,861	244	32.7	34.3	18	15
	Oct	1,491	37	1,453	190	31.6	32.7	19.2	16.5
	Nov	435	27	408	54	36.5	39.9	13.8	9.8

Kindly help?

Thanks and Regards,

Rohit Yadav

[vinay_hg]

in the Expression -->

background color expression.. write an expression like

if(max(expression), rgb(0,255,0))

[anbu1984]

Check this

[sujeetsingh]

Rohit,

Expressions have Attributes as shown in Vinay's screenshot image.

Use Text Colour attribute and write down the condition you want

For example

If(sum(Sales)>=500,LightGreen())

This will colour all 500 and greater values to light green colour

[ashwanin]

Go to Expression -->Click on + sign --> Text -->Definition (add formula)

ie if(max(expression), rgb(0,255,0))

[rohitians]

Hey,

I did the same i used rank function instead

Thanks for your help..

Thanks and Regards,

Rohit