Spotfire Ideas Portal
We have a cross table where some columns (e.g. sales total) benefit from a grand total, whereas others (e.g. the sales rank of a product against other products) do not. We would like to have the option to choose whether a column gets a total.
Additionally, when we calculate the rank using a THEN expression, referencing the row axis (because it is hierarchical), we lose the ability to show column totals completely because "When using grand total for columns, the cell values expressions may not refer to the levels on the vertical axis (Rows.*)". We don't want the total for this column, so this is doubly frustrating!
1
Future Consideration
I've been recently discussing this with colleagues and would love to see this as a simple addition under the "calculate totals" section within the totals property. It would be great if there were a third radio button option for the selected calculation to simply "ignore total" for the selected category.