by Admin21. November 2012 00:06We are often asked "How to display totals by all levels?" or "how to display totals by the values in the table?". Let us see some examples.
Example 1: "physical" total
Australia has 4 states. If we hide one of them
we will get this:
The values aren't changed, as if nothing happened. This is because by default the table shows physical totals which are in the cube.
Example 2: "Visual" total
Let us switch visual totals:
And see what changed:
The values for Australia changed, and now it takes into account the selection made by user.
Deprecated Functionality
BAT has one more functionality for displaying totals:
This is a deprecated functionality which finds just the sum, no matter what kind the measure is. It does it on a client machine, instead of doing it on the server.
If you want to have your totals calculated FINE (taking into account aggregation type, but not just sums), you need to do this:
And choose what you need to look – visual totals, or physical totals. And if you do this, you will have CORRECT totals on every level.
And please, FORGET ABOUT "Show Summary Rows/Columns" FUNCTIONALITY – IT IS AND OLD STUFF WHICH WILL SOMETIMES BE THROWN AWAY.
Why do we still keep this old functionality? Cause people are asking not to remove it. We would do it long ago.
Conslusions
Use member selector to show necessary levels and use visual totals if necessary.
ba1a8ecb-f40c-4e85-a8b4-cf11b2ccaae1|0|.0|96d5b379-7e1d-4dac-a6ba-1e50db561b04