This is the sample data that I have it in pivot table. Imagine if the target is 85% for all the columns C1,C2 and C3. I want to show one image in a seperate column very next to each of these columns(C1,C2 and C3). C
Criteria is if C1 > 85% I want to show how much % is the difference. If the difference is in +ve i have to show the up arrow(image) and if it is in -ve I have to show the down arrow(image). Also very next to that image column I want to show how difference when compared to 85%. For example if the difference is in +ve I have to show the difference in +ve and if the difference is in -ve I have to show the difference in -ve.
Group SubGroup C1 Image Value C2 Image Value C3 Image Value
G1 G1.1 71% Down -14% 87% Up +2% 65% Down -20%
Hope someone can help me out!