0 Replies Latest reply: Dec 16, 2010 9:35 AM by At titude RSS

    Pivot table with images and value difference

      Hi,

      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!