Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try
Sum(
{
1<Metric_Name={'Armored'},
GoalMonth={"<=$(vCurrMonth)"},
AEName=$::AEName
>}Target)
Try
Sum(
{
1<Metric_Name={'Armored'},
GoalMonth={"<=$(vCurrMonth)"},
AEName=$::AEName
>}Target)
let's try using the below expression:
Sum({1<Metric_Name={'Armored'},GoalMonth={"<=$(vCurrMonth)"},AEName=$::AEName >}Target)