0 Replies Latest reply: May 15, 2014 9:58 AM by Glen Nickerson RSS

    Summary Table Coloring

    Glen Nickerson

      A question regarding the Color dialog on a Summary Table.

       

      I have a Summary which contains 5 Keys, 5 Item fields, and 9 Measure fields. I would like to establish a backgroung color for the entire row based on 1 of 4 values in the lowest level key. The key was established as a calculated field based on elements within the table which has to do with sales trends.

       

      In effect, I would like to color all of the Item and Measure fields green if the key element has a value of "Sales Up / Margin UP", yellow if the value is "Sales Up / Margin Down" and so forth. Any help would be appreciated.

       

      Nick

      Monarch v8.01 Pro