Jump to content

Is it possible to calculate grand total base on the 'Showed items' only


Recommended Posts

Hi all,

I want to make a cross table that only display the records below 92.5%, therefore I added a rule in 'Show/Hide Items'.

The problem is that those 'hidden items' are still counted in the grand totals.

As the image attached below, after adding the rule,

Grand totals of call = 503 + 708 = 1873 (which is incorrect)

Is there a way to solve this problem

Many thanks.

Link to comment
Share on other sites


See my attached pictures for how you can calculate the grand totals based on the cell values rather than the underlying values (which is the default).

In my example, you can see that the state of Illinois has a total of 2110 (2100 + 10) when I have no rule applied. when I apply my rule (hide every value under 25), the 10 is not showing anymore. But is still counted for in the Grand total. Unless I select the Grand total to be based upon the cell values. Then you see the correct Grand total figure of 2100.

When it comes to coloring, please (left-mouse) click on the Grand total header and select the approriate color as well as checking the box for 'Stylethis column individually'. That should color your Grand total column (same is true for Grand total row).

Kind regards,

David Boot-Olazabal

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...