1 of 1 people found this helpful
I usually do this inside a calculated field with an if statement. For example:
IF [Year] = 2014 THEN [Sales] END
Thanks so much for the help. I ended up adding an IF statement to my calculated and also had to make adjustments to account for the aggregate vs non aggregate error.