3 Replies Latest reply: Aug 15, 2013 9:13 AM by Andrew Meyer RSS

    Coloring a horizontal dimension in a pivot table based on dimension value

      Is it possible to change the background color of a HORIZONTAL dimension field in a pivot table based on its value?  I can get it to work when the pivot dimension is vertical, but not when going across the top.

       

      In my attached example, i have 2 pivot tables.  The first one correctly highlights the dimension labels based on its valyue of A. B and C.  However, the second pivot does not work because the dimension is pivoted horizontally.

       

      Any ideas?

       

      Thanks,

      Andrew