Hello,
I have an subtotal at the bottom of a matrix associated with a row group. How can I change the color of the background in the subtotal based of the value that subtotalled inside it without changing the background of another cell in the detail area if the value there matched the same criteria. I tried putting an expression in the detail, and it changes the color in both the detail AND subtotal....I only want to affect the subtotal...
I also tried changing the expression for the background color of the whole row that's created when I added the subtotal
thanks in advance!
Start Free Trial