Hello Spotfire Admins.
I would like to suggest that you give users the capability to choose what columns they want to be included in the summation of grand totals. If I were to make the Vertical Axes columns on a cross table all the columns that I need, and the Horizontal Columns all the columns that I need calculated, I will not be able to see the all the Horizontal Columns along with the Vertical Columns due to the real estate being used up on the page and because the scrolling capability is not available for the Vertical Axis. So what I had to do was create a few vertical axis columns and included the rest as horizontal columns. The con is that the grand total is showing up for all the horizontal columns and doesn't really make sense to do so.
Hi Mohammad, thank you for contributing. To make sure I understand your point, would it be possible for you to provide a screenshot with some explanation? Also, which version of Spotfire are you currently on?