You are connected to your server please attach an extracted workbook. So that I can open it
1 of 1 people found this helpful
Hi Matt(gikarp)! This isn't a bug per se, but you're hiding columns using table calculation filters, and that method isn't compatible with grand totals, unfortunately. There are requests in the Ideas section to change this behavior.
One way to get around this is to simulate grand totals using another sheet. Just make a dashboard, put the current sheet on it, and then make a duplicate sheet that has nothing in the Rows shelf. You can put that new sheet under the old one in the dashboard so it kind of looks like a grand total.
this behavior "worked" in 9.3, but now doesn't in 10.x
a table calc used as a filter with grand totals only showed the visible data as intended. however, when we upgraded our server to 10.0, folks using this technique noticed that the grand totals were being displayed for the hidden data. a simple example is attached using both v9.3 and v10.0.1.
what changed and why? anyone know? if there's a valid reason ... fine. but there have been so many bugs in 10.0, that i want to be sure this isn't another before we resort to the standard workarounds.
Huh, that's interesting. I don't know why the behavior should differ between 9 and 10, but I've personally never been able to get the grand totals to properly hide in any version, so I'm afraid I won't be much help in explaining the difference.