Cell Filtering not affecting totals

[ttgchicago]

Alex -

If you use the cell filtering options (min, max) in the Measure manager, the filtered amounts are still showing up in the row and column totals.

Do you consider this a bug? Its very confusing to the users to see the totals not match the sum of the displayed values.

Is there possibly a property Im missing which handles this?

Bob

[AlexZencovich]

1
Filtering by map cells just not recalulate totals. It just hide from grid values which does not meet filtering conditions.
It has just cosmetic effect, to remove extra rows/columns from grid which may not affect to desciotn, like in Pareto anaylysis (remove 80% rows which produced only 20% of total)

2.
If you would like filter out some values so it will affect on totals, you may set filter to afct table records. It remove from calulations some cube data and change all calculations.

[ttgchicago]

Alex -

Should cell filtering work for views other than Value? In other words, should I be able to filter Rank where max value = 20 to show me only my top 20 columns for a dimension?

[AlexZencovich]

No, cell filtering work only on absolute values