Hi,
I have a table where I use the following expression with the {1} operator to prevent the data from changing when filter selections are made.
Count({1<Ex_Flag={'Excluded'},[HW Lifecycle Status] -= {'Disposed'}, [SW Lifecycle Status] -= {'Disposed'} >} SW_CI_ID)
This seems to work fine. But I also have the following expression in the background color of one of the dimensions to do some color coding.
=if((V_Class) = ('High'),rgb(255,0,0),
if((V_Class) = ('Medium'),rgb(255,217,47),
rgb(69,234,21) )
When I use make a filter selection, the data remains the same, but the background color coding changes/
How do I apply the {1} operator to the Background Color Expression?
