Spotfire Ideas Portal
*Goal:*
Ability to hide Sub/ Individual Columns in Cross table. The need arises when a cell metric involves an OVER expression that will always result in an empty column at the far end of the Cross Table.
Example:
When we use OVER function in ‘custom expression’ for Cross table it shows empty at the far end.
Attached a small test case to clarify my point. It should be no more than hiding a column in Excel...solving the rigidity of pre-transforming the data and, in case of transposing, the multiplication of derived fields as inputs (to be manually named and managed within the formulas).