Are you trying to color the text, a bar, or the space behind the text?
Creating a calculated field similar to the following will help you get the correct Name/Asset to be colored appropriately:
if sum(Asset)=window_min(sum(Asset)) then 'Red'
elseif sum(Asset)=window_max(Sum(Asset)) then 'Green'
else 'white' end
Then, place this on the color shelf. As per Alex's question, the different marks may change the way this is done.
Hope this helps!
I am trying to change the colour of text.
But also want to know to how to change the colour of space behind the text.
When I am trying to create a calculated field as you mentioned above, it gives following error
'All field must be aggregate or constant when using table calculation functions or fields from multiple Data sources'.
Are you using the calculation exactly as Tracy wrote it? If you are not, for example just using [Asset] instead of SUM([Asset]), or WINDOW_MIN([Asset]) instead of WINDOW_MIN(SUM([Asset])), you will get the aggregate or constant error. If you are still having problems, then I suggest you post a packaged workbook (.twbx) format with some sample data.
You'd also asked about coloring the background, there are three ways to do this, one is to format the worksheet background, the second is to use banding, and the third is to use a highlight table. There are examples of all three in the following workbook: