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 column. So I need to create a measure that will allow me to use the conditional formatting function. 

 

I have a matrix that has customers as the rows, products as the solumns, and average sale price as the values. The column subtotals are the average sale price for the whole column (product). So if a customer has an average sales price for product X that is less than the overall average sale price of product X, that value should be shaded red. If a customer has an average sales price for product X that is higher than the overall average sales price of product X, that value should be shaded green.

 

 

I appreciate your help!

2 Replies

    • 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