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.