This content has been marked as final. Show 2 replies
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?