IF [Field1]='My Condition' AND [Field2]='My Vague Question' THEN 'Conditions are met' ELSE ' ' END
Place this as a discrete pill on the row shelf next to Area
If I understand your problem, you want to calculate something ignoring the dimension you have in the color shelf. It sounds like you need a table calculation or perhaps a dual axis view with different levels of detail for each view.
Please post a packaged workbook with any confidential data masked and explain better what you are trying to achieve and people in the forum will be able to help you.