Re: Set Analysis multiple criteria different sources
Thanks Frank, screen shot below:
As you can see May & June actuals are currently $0 as they are future months. I only want the Budget KPI box to show values up until April ($500K), ignoring the future months.
So whenever actuals = $0, ignore those budget months (being May & June in this example).
Note: Budget figures currently pull from an excel file which also contains Forecast numbers in the same column. Column name is "Scenario", filtering on "Bud" which excludes the forecast figures. i.e. Scenario = Bud