Cross Table Grand Total for a secondary table column does not respond to filtering in TIBCO Spotfire

Cross Table Grand Total for a secondary table column does not respond to filtering in TIBCO Spotfire

In a cross table, if your value axis uses a column from the secondary table (linked to the main table), and you filter out some values in this cross table, you might notice that the grand totals for rows or columns remain unchanged.

For Example, below is the data set without any filters and STATE_NAME is the column from secondary table:
This is because the secondary data table will fetch values based on column matches and filter application will not have any impact on that with the default filtering configuration. To make this work with the filtering, the filtering panel settings for related tables will need to be updated.

First, make sure you have the data table relations present between the two data tables. See "Data Table Properties - Relations" for more details. Here, The main data table is "SalesAndMarketing" and the secondary table is "usa_st":
Doc: Data Table Properties - Relations

• https://docs.tibco.com/pub/sfire-analyst/10.3.0/doc/html/en-US/TIB_sfire-analyst_UsersGuide/data/data_details_on_data_table_properties_relations.htm

• https://docs.tibco.com/pub/sfire-analyst/10.3.0/doc/html/en-US/TIB_sfire-analyst_UsersGuide/filter/filter_filtering_in_related_data_tables.htm