How to Toggle Sub Totals in a CrossTable in Spotfire® Using IronPython Scripting

Introduction

Below is a sample IronPython code to toggle SubTotals in a CrossTable 

Code Sample

# Copyright © 2017. TIBCO Software Inc. Licensed under TIBCO BSD-style license.

from Spotfire.Dxp.Application.Visuals import *

#add a script parameter vis referring to the cross table visualization

crossTable=vis.As[CrossTablePlot]()
for sub in crossTable.ColumnSubtotals:
	if sub.Visible:
		sub.Visible=False
	else:
		sub.Visible=True

References

• API Reference: CrossTablePlot
• API Reference: ColumnSubTotals
• API Reference: CrossTableSubtotalCollection

License:  TIBCO BSD-Style License