I want to hide one row created in Spotfire cross table.

[Mansi Joshi]

Hi All,

I am creating difference of 2 measures in Spotfire cross table so one row is getting created as diff.

for ex,

in cross tab I have Aand Bmeasures in row and I am calculating A-Bso one more row A-Bis getting generated and user don't want to see this A-Brow in cross tab. I am creating A-Bcalculation to apply color code in cell so please let me know if it is feasible to hide A-B row in cross tab.

Please find attached sample image for the same.

Thanks in advance.

Thanks & Regards,

Mansi Joshi

[Kirsten Smith (she/her)]

Click on Show/Hide Items and create a Rule for the row you don't want to show, and set it to Hide items that match the rule

[Mansi Joshi]

I did try with show/hide option but it seems this row I can't hide in that way. Could you suggest what rule can I apply to hide A-B row.