Forum Discussion

cbolling's avatar
cbolling
Helper I
5 years ago

Conditional Formatting Matrix Values based on the column subtotals

Hi All,   I have a client that wants to shade the values in the matrix red if that value is less than the subtotal in that column, and shade it green if the value is more than the subtotal in that ...
  • cbolling's avatar
    cbolling
    Helper I
    5 years ago

    Hi,

     

    I already know how to conditional format. But I need help to base it off of the subtotals in the matrix. I either need a measure that is a 1 if selected value is higher than the subtotal for all, or a 0 if the selected value is lower than the subtotal for all. Then, use the value of this measure to create the conditional formatting. I am not sure how to make this measure though.

     

    Thanks