Is it possible to only have a calculation execute when the dimension is above a given value? As an example;
Years = 2010, 2011 and 2012
Actual Sales for 2010
Budget Forecast and Actuals for 2011
Budget and Forecast for 2012
I want to compare 2011 Budget versus Forecast so there wouldn't be a variance calculation for 2010 - so I want to show only Actuals; however for 2011 and 2012 I want to calculate the variance between actual sales and the 2011 Budget. Is it possible - if my scenario makes sense!?