Stephen
There are two possible causes:
- 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
