Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
in the Expression -->
background color expression.. write an expression like
if(max(expression), rgb(0,255,0))
Check this
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
Go to Expression -->Click on + sign --> Text -->Definition (add formula)
ie if(max(expression), rgb(0,255,0))
Hey,
I did the same i used rank function instead
Thanks for your help..
Thanks and Regards,
Rohit