2 Replies Latest reply: Mar 26, 2018 9:25 AM by Andrea Gigliotti RSS

    Set Analysis Help

    Mark Ritter

      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.