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:


Now, if you apply any filter in main data table, it can be observed that first column grand total is changed but not for column from secondary data 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":

If you set the secondary table to include filtered rows from the main table, i.e. changing from "Ignore Filtering" to "Include Filtered Rows Only", the grand total for the secondary data table would appear correct as seen below. See " Filtering in related data tables" for more information.

This article explains why the Grand Total for a column from a secondary data table in a Cross Table does not respond to filter as expected.

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

Doc: Filtering in related data tables

• 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