8 Replies Latest reply: Sep 14, 2017 6:15 AM by Anil Babu

# Highlight Certain Fields

Hi,

I am having an issue highlighting certain fields in my pivot table.

I have a dataset like this.

% of cars

1

2

3

4

5

6

7

8

9

I am using the following IF statement to arrange them into groups within the pivot.

=if ([% of Cars] <5, '<5%',

if ([% of Cars] <=7  , '6-7%',

if ([% of Cars] <=8 , '7-8%',

if ([% of Cars]  <=9, '8-9%',

if ([% of Cars]  <=10, '9-10%',

if ([% of Cars] >10, '>10%',

))))))

The script works fine in sorting them into their designated fields. However I would like certain fields such as the <=10 and >10 to be in Red. I would like <5 and <=7 to be green. Does anyone know how to achieve this? I have tried for quite a while and I can not seem to find a solution.

• ###### Re: Highlight Certain Fields

May be this?

• ###### Re: Highlight Certain Fields

This doesn't work for me.

=if ([% of Cars] <5, '<5%',

if ([% of Cars] <=7  , '6-7%',

if ([% of Cars] <=8 , '7-8%',

if ([% of Cars]  <=9, '8-9%',

if ([% of Cars]  <=10, '9-10%',

if ([% of Cars] >10, '>10%',

))))))

how would i colour each cell. so for >10 red ,<= 9 blue etc. your trick doesn't work as i am using the script shown above.

• ###### Re: Highlight Certain Fields

Like this?

• ###### Re: Highlight Certain Fields

What is the as Field Inline?

This is my current script in the dimensions.

=if ([% of cars] <5, '<5%',

if ([% of cars] <=7  , '6-7%',

if ([% of cars] <=8 , '7-8%',

if ([% of cars]  <=9, '8-9%',

if ([% of cars]  <=10, '9-10%',

if ([% of cars] >10, '>10%',

))))))

From here how would i assign certain colors?

• ###### Re: Highlight Certain Fields

Have you opened my script?

LOAD *, if ([% of cars] <5, '<5%',if ([% of cars] <=7  , '6-7%',if ([% of cars] <=8 , '7-8%',if ([% of cars]  <=9, '8-9%',if ([% of cars]  <=10, '9-10%',

if ([% of cars] >10, '>10%')))))) as Field Inline [

% of cars

1

2

3

4

5

6

7

8

9

];

• ###### Re: Highlight Certain Fields

Yes i did - However , the data is being read in from a excel file with 100s of lines so i cannot add the "as Field Inline Script in the main script editor - I am adding the Script from the Chart properties -> Dimensions then adding my script

• ###### Re: Highlight Certain Fields

Please post sample application and design colors for cells?

• ###### Re: Highlight Certain Fields

Hi,

You can set this in the background colour of the dimension