I have the below pivot table data with Country, Service Lines and Sales%
Country
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
A
40.0%
12.0%
6.0%
1.0%
-5.0%
12.0%
5.0%
-1.0%
6.0%
13.0%
-40.0%
35.0%
145.0%
9.5%
11.1%
-18.0%
245.2%
16.3%
-69.5%
B
1.0%
1.0%
3.0%
56.0%
45.0%
23.0%
8.0%
10.0%
6.0%
56.0%
34.0%
-10.0%
-20.0%
-30.0%
37.4%
90.0%
8.0%
6.0%
-70.0%
I need to show Increase Icon for highest % and nothing for other %
For example, for country A, highest % is 145% which should show icon and the rest all values for Country A should be blank.
I understand that we can do a custom format cells, but the value 145% is not constant and once data changes the highest % may go to other service line.
I think you might be using number fromatting from numbers tab, change that to expression default and use num function to format the max value in % format
