Hide column in cross table

[mrunali tembhurne 2]

Can anyone help me how can we hide any column in cross table.

 

Thanks,

Mrunali

[Pierre-Jacques Evrard]

Hi Mrunali,

 

Have you tried the Show/Hide items feature in the properties of the cross table

You then choose the column you want to hide, raise the value and choose the "Hide items" option

 

pj

[mrunali tembhurne 3]

Hi Pj,

Thanks for your support

That option will work for direct column but i need to hide calculated column.

eg:(for date will have year, month and day) so i want to hide only year of date column.

[Keyur Parekh 2]

I also came across this situation. Any suggestions

[Sade Ok]

Hello, I had the same probem and solved it as stated below. I know this reposne is 3 years late, but I hope it helps someone.

1) Right click the visiualisation

2) Click Properties

3) Select "Columns" in the left section of the window

4) To hide a column, go to the "Selected columns" section, select the column you want to hide , "Remove"

5) To add a column,go to the "Available columns" section, select the column you want to hide , "Add"

In general the "Selected columns" section contains all columns that are visible in your cross table

I hope this helps

[Neil Kanungo 2]

# '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]=0