Would appreciate your help with an issue I am facing using the Cross Table functionality in Spotfire 5.

Hi all,

Would appreciate your help with an issue I am facing using the Cross Table functionality in Spotfire 5.5

I have one that looks like:

                       

"Country"  "0" "1"

     A           1   1

     B           1   ---

     C           ---  1

And I want to hide the row where there is no data in the "Late" Column. The distinction between On Time and Late is derived from a calculated column, so the actual table where this is derived from looks like (very much simplified, actual table contains about 30 columns)

"Country" "Date1" "Date2" "Late"

     A          1-5-14    1-5-14      0

     A          1-5-14    2-5-14      1

     B          1-5-14    1-5-14      0

     C          1-5-14    2-5-14      1      

The Cross Table is created with "Late" as horizontal Axis, "Country" as Vertical and the cell values are a simple (Row Count). Any suggestion how I can achieve this? I have been playing around with Hide/Show Items but to no avail. Thanks in advance!

(2) Answers

Login