Using values from one visualization to create another

[Casy Horsley]

I have a cross table that uses calculated columns to give values for "Yesterday", "MTD" and "YTD". I need to create another visualization that will use the cross table data as a data source so that I can pull the totals by summing certain values in the cross table. I thought I saw a video once that did this but I am unable to locate it or the instructions on how to do it. Can someone guide me on where this is Basically using one visualization stored as a table for another visualization to use as a data source. Thank you.

[Donald Johnson]

I suppose that this is a TIBCO Spotfire question

[Casy Horsley]

Yes...

[Fabian Duerr]

The cross table is aggregating certain values. In principle you can do the aggregation in any visualization as well. But I know that this can get complicated.

I understand your approach but I don't know if that is possible...

But you can always create the same cross table result by doing your own pivot operation (add new table with pivot operation). This will end up in a new data table where you can easily operate with the values. This table will also refresh when values in the original table change. Whereas the cross table will recalculate when you apply a filter, the pivot operation will take the entire data set. So you have to do the filtering afterwards.