Spotfire Ideas Portal
With a cross table I'd like the option to have the "Grand total" match the aggregation method for the column and calculate on only the visible rows (based on show/hide criteria).
For example: if the column is calculating the avg(sale qty), which rows for each district and a show/hide rule to show only those districts with sales of a specific product. I want the option to have the Grand total be the Average of that "avg(sale qty)" column based on just the rows visible and not all the "Underlying row values" that include values filtered from view by the show/hide rules.
With the current functionality, the options are either:
"Underlying row values" = Use the aggregation method from the column but include all underlying rows in the calculation.
"Sum of cell values" = Calculate a Sum and use just the visible row values from the column.
It would be very useful for these settings to be independent (e.g. set the aggregation method separately from the values included).
There are several other ideas I noticed that are similar (SPF-I-777, TS-I-5862, or SPF-I-2515), but the implemented functionality does not meet this need.
Corey,
Changing the setting for the vertical axis to evaluate axis expression on "Current Filtering Only" doesn't appear to show the expected values.
The value in the grand total row (in my case for an average calculation) still evaluates based on the entire set of data (based on the filters applied), as opposed to only the visible values based on the "Show/Hide Items" rules.
If you go to the Cross Table visualization properties, Axes properties, Vertical axes settings, and select the radio button for Evaluate axis expression on: "Current Filtering Only" does this achieve your desired result?