Jump to content

How do I show row value for every row of a Cross Table in Spotfire

Neil Kanungo 2

Recommended Posts

There's a little trick where you can use IronPython to hide Header Columns in Cross Tables:

# 'vis' is a script parameter


# Import Modules

from Spotfire.Dxp.Application.Visuals import *


# Set row header column width to 0 (i.e. first column)

vis.As[CrossTablePlot]().RowHeaderWidths.Item[0]=0Why would you want to do this Well, you can add new 'Axes' columns to your cross table for what would be your header column(s), then use the First() aggregation for those columns. In this case the headers are 'Manufacturer' and 'Division':



After doing this, you can use my above script to hide the first column(s) which are really "Header Columns". (Just make sure to adjust the index number in the square [ ] brackets for your column number, with index starting at 0).

Then you can also go back to your axis configuration and make the names prettier:



Maybe I'll make a video on cross table tips like this sometime...

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...