Jump to content

Is there a way to create dynamic calculations based on what a Cross Table is displaying

Chandler Terrell

Recommended Posts

I have requirements to create a report with a fixed format. The best way to address 99% of this is to use a Cross Table. However, there are some dynamic calculations (like Price) that need to change as the Cross Table changes when filtered. However, I can't really create that in a super easy way. I have used a combination of UnPivoting, Calc Columns, SUMOVER Intercept, Nodes, RowCount, etc to address this - but it is all a little too cumbersome and never really accomplishes the simple calculation I need.

Is there a way to create more of a "fixed format" report.I need Spotfire to work more like Excel in this one instance. The Calc would be the SUM of Row A / SUM of Row B in the Cross Table.



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...