1 of 1 people found this helpful
Create a calculated field;
IF NOT ISNULL([Parameter]) THEN
IF [Scenario] = 'Revised Estimate' AND YEAR([Date]) = [Parameter] THEN 'Show'
IF [Scenario] = 'Actual' AND YEAR([Date]) < [Parameter] THEN 'Show'
Add the field to the filter shelf and select 'Show'.
Hope this helps.
thanks so much for reaching out. It almost works. So your calculated field shows now 2017 and earlier actual figures, but instead of showing the revised estimate figures for 2018 (which is how I set the parameter) it hides 2018.
I did not yet get my head around what I might be missing. What's the ISNULL bracket doing?
Thanks so much
The ISNULL() line of code is used to anchor the formula. It says, if the parameter is not null then do something. I tested it on Sample Superstore dataset and it works fine. There has to be something with your data stopping it from working. It might be a typo.
Check to ensure that 'Revised Estimate' in your database is spelt exactly as you spelt it in the formula. Check for upper and lower case inconsistency.