Jump to content

How to display grand total from Cross Table into a Text Area

Charles Wong 2

Recommended Posts

Hello All,

Fairly new to Spotfire, but I am having trouble figuring out anexpression to display an aggregated grand total of my data set.

In the attached spreadsheet, I have my data set in the table on the left. Within Spotfire, I was able to createthe cross table on the right, using an avg aggregation on the Type Well column. Spotfire also let's me display the grand total of the aggregation, using the Properties --> Totals --> Sum of Cell Values selection. The cell highlighted in yellow is the desired result that is produced.

Is there a way that I can replicatethe grand total result (aggregation included) in a custom expression Given I'm still very green with Spotfire, I seem to get the total sum of all the data (non-aggregated) whenever I try to create a grand total expression in a text area but I'd like to get the result that is highlighted in yellow.

Hopefully the question is clear.

Thanks for any help!



Link to comment
Share on other sites

Have you tried to use the pivot transformation and use the pivoted table as a help table for your calculation In your example you would just need to involve the columns you need (see screenshot). Based on this help table it is pretty straight forward to build the custom expression in the text area (just sum) and the table is linked to the original one (it remains interactive with markings and filters).
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...