CODEWITHSUNDEEP
spotfire
sasecse
sasecse

Reputation: 69

Exclude "No Value" in Spotfire Cross Table

Is there any way to remove the "--" (No Value) in the cross table. Instead of "---" I am trying to make it as blank? I am using a aggregation function. Appreciate your thoughts.

enter image description here

Upvotes: 1

Views: 3517

Answers (2)

Bruno Medeiros
Bruno Medeiros

Reputation: 2399

If you are on Spotfire version 7.7+, you can configure what is displayed in the cross table for empty values via Tools > Options > Cross Table > Display cells with no data as: and put and empty string. Ref: Spotfire forum.

Upvotes: 1

niko
niko

Reputation: 3974

TIBCO has an enhancement request for this, but it's not high priority.

unfortunately there's no workaround other than inserting data into your data source that will evaluate to 0 instead of NULL.

Upvotes: 0

Related Questions