Iron Python script for cross Table taggle Rows Grand Total

[Naveen Tibco]

can any one help me script for cross table rows Grand Total in a cross table.

Thanks

Naveen

[Khushboo Rabadia]

You can use below script to show/hide Grand Total for rows:

from Spotfire.Dxp.Application.Visuals import *

 

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

 

crossTable=vis.As[CrossTablePlot]()

result= crossTable.ShowRowGrandTotal

if result== True:

crossTable.ShowRowGrandTotal=False

else:

crossTable.ShowRowGrandTotal=TrueReference:

https://docs.tibco.com/pub/doc_remote/sfire_dev/area/doc/api/TIB_sfire-a...

[Naveen Tibco]

Thanks for your inputs.....i tried with your code but i am getting below error 

 

 

 

[[{"fid":"165356","view_mode":"default","fields":{"format":"default","field_file_image_alt_text[und][0][value]":false,"field_file_image_title_text[und][0][value]":false,"height":"","width":""},"type":"media","field_deltas":{"1":{"format":"default","field_file_image_alt_text[und][0][value]":false,"field_file_image_title_text[und][0][value]":false,"height":"","width":""}},"attributes":{"class":"media-element file-default","data-delta":"1"}}]]

 

 

[Naveen Tibco]

colud you please suggest me where i did wrong.... and also i would like to get specific column grand total in cross table....do you have any idea