Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
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.
Request to please help on the same.
Thanks
Satish
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
Thanks Sunny, It worked...