how to display the grand total of visible values in a column in spotfire cross table

Is it possible to display the total of only the visible columns in spotfire, or can it be done using ironpython scrpiting?

In the attached image the grand total for column "mix impact" is 0 although if we total it for the same then its

Since,  the grand total calculation goes back to the underlying data table, and its data row values, is it possible to display the total for only visible values using ironpython scripting?

(2) Answers