2 Replies Latest reply on May 12, 2015 7:33 PM by 2778155

    Color Formatting - Pivot table

    2778155

      Hi,

       

      I have one calculated column under rows section in  a pivot table having Pass / Fail values. I want the font for PASS with green and FAIL with red color. I tried conditional formatting for this column. But the colors do not work. If I get this column under measures, and change the aggregation level from default to First/ last/ Max then I can see some colors but I get wrong values. Can someone please help me in this case.?