Year is not properly linked to the fact table in your model, so selecting year does not change the totals.
vMaxYear is not working properly.
To check the first, verify the that the Sums or Counts change when you make a selection of Year. If necessary, add a Year list box.
To check the second, create a new chart/table, enter
Sum({$<Year={'$(=vMxYear)'}>} Sales)
as the expression. Do not enter an expression label. Now the table caption should display the expression without the $ expansion and the column label should display the expression with the dollar expansion. That should give you a clue as to what's happening.
HTH
Jonathan
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
