Set Analysis Help

[rittermd]

I have a main sheet with a bunch of metrics that I only want to change when the filter AEName is chosen.  All other filters should be ignored.

This is how I coded one of the expressions. 

Sum({1<Metric_Name={'Armored'},GoalMonth={"<=$(vCurrMonth)"},AEName=P(AEName)>}Target)

It works perfectly when I select an AEName.  All other filters are ignored. 

The problem I am having is when no AEName is selected (all data).  When I click on other filters the values do change and I don't want this to happen.

I am not sure what I need to add or change in my expressions to make sure that AEName is the only filter that ever changes the values.

[MK_QSL · Accepted solution]

Try

Sum(

     {

          1<Metric_Name={'Armored'},

               GoalMonth={"<=$(vCurrMonth)"},

               AEName=$::AEName

   >}Target)

[agigliotti]

let's try using the below expression:

Sum({1<Metric_Name={'Armored'},GoalMonth={"<=$(vCurrMonth)"},AEName=$::AEName >}Target)