4 Replies Latest reply: Aug 11, 2014 1:21 PM by 1049231 RSS

    How do I apply conditional formatting to a measure (which is defined by Show Data As on a duplicate layer) in a pivot table?

    1049231

      I have a simple pivot table with 2 elements (Clerk ID and Indicator) and a measure (Number of patients). I created a duplicate layer from the measure to obtain a second measure which is a percentage of the number of patients by indicator for the clerk ID. (Show Data as > Percent of > Layer > Clerk ID) Now I want to highlight percentages > 50 for indicators of 'Y'. There is no Conditional Format tab for the pivot table Format Measure Values. And I can't place the conditional format on the column properties of the Criteria column because I need the percentage value as my condition, not the count from the original query. Any suggestions?