This content has been marked as final. Show 3 replies
Returns the sales for current selection, but with new selection year=2000. if someone applies a filter year=2001, the above set analysis still returns sum of sales for year 2000. How do i modify this so that if a user applies no year filter it return sum of sales for year 2000, but if a user applies a filter year other then 2000, then the function returns 0?