O'Reilly logo

TIBCO Spotfire – A Comprehensive Primer by Michael Phillips

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

How to create dynamic pivots using cross tables

We're going to spend the rest of this chapter covering most of the remaining visualization types in Spotfire, starting with the Cross Table. In Chapter 5, Source Data is Never Enough, we looked at data pivoting, and we've also seen an example of pivoting in the graphical table, where we tabulated a high-level category—baseball team—and aggregated some values against it from the player level.

The Cross table is a dedicated and feature-rich visualization tool to do these types of pivots without the need to transform any data. The cross table does the transformation for you on the fly. There are two main reasons to use a cross table:

  • Rolling up, or aggregating, data values to a category in tabular form ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required