We have a simple calculated field in a cube that looks like this:
[Measures].[Value] * [Measures].[Factor]
This works great when we slice it year by year in rows. The problem is when we use year as a filter in the cube browser (BIDS) we always get the same total, no matter what years we have selected.
How can we make the filter work with calculated fields?
View Complete Post