In the last blog post I mentioned that Cross Tables in Spotfire are a great way to quickly summarize data and evaluate data relationships. If you’ve worked with Cross Tables in Spotfire, you’ve probably noticed their similarity to Pivot Tables in Excel.
[ninja-popup ID=1967]CLICK HERE To download the Spotfire template shown in the video. [/ninja-popup]
The challenge with Cross Tables is that it’s difficult to perform calculations between columns, such as the “Type 1 – Type 2” column in the screenshot above. There is a feature to calculate the grand total of all columns, but no other mathematical operations built in the cross table.
In the the last post, I showed one way to perform Cross Table calculations by applying a pivot transformation to the data table, and then use the pivoted columns in a custom expression of the Cross Table value axis.
In this 2nd example, we’ll stick with the same starting data and Spotfire file. To quickly reset the scene, let’s say you have a Cross Table with 2 columns as in the screenshot below. You might want to perform some calculations between these 2 columns, for reasons explained in greater detail here.
The video below describes another method for performing calculations in a Cross Table by adding Calculated Columns to the data table. Check out this video to see the exact steps to achieve the final result shown in the first screenshot above.
If the embedded player above isn’t working, this video is also on YouTube: https://www.youtube.com/watch?v=ht77CMyO6oA
Questions / Comments
I hope this has been a helpful demonstration of cross table calculations in Spotfire. If you have any questions or comments, or if there’s something you’d like featured on this blog, feel free to leave a comment below or email me at firstname.lastname@example.org.