Exception highlighting on dimension on table containing set analysis

[amweiner]

I have two pivot tables containing several dimensions and expressions. We use set analysis on the expressions to limit the contents in the table. All data falls into two category values "Y" and "N". One table contains expressions qualified by "Y", and the other table contains expressions qualified by "N". Both tables display data as excepted.

I now need to add exception formatting to one of my dimensions. After I add the exception criteria and color to the dimension (select dimension in the dimension tab, select "text" under the field name,edit, and enter a logical expression that assigns the color when the condition is true), the table no longer filters based upon the set analysis. So, my table that was originally displaying "Y" records, are now displaying both "N" and "Y" records.

Is there a way to overcome this issue?

[calvindk]

I would think you could handle this in 2 ways.

Add your set condition to the coloring,

or add a calculated dimension and use it to suppress the results you dont want.

[amweiner]

Thanks for the tip. I used the following syntax for each field in the expression:

concat({Set} FieldName)