Spotfire Ideas Portal
Add a new idea Subscribe
Status Future Consideration
Product Spotfire
Categories Visualization
Created by Guest
Created on Feb 6, 2016

RELATED IDEAS

Allow user to hide Sub/ Individual Columns while using OVER function in a Cross Table.

*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.

  • Attach files
  • Guest
    Dec 21, 2016

    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).

    sf7_test_case.pdf
    spotfireYoY.xlsx
    sf7_test_case.pdf
     sf7_test_case.pdf
    Open full size
    spotfireYoY.xlsx
     spotfireYoY.xlsx
    Open full size
    sf7_test_case.pdf spotfireYoY.xlsx
    Reply
The material provided is for informational purposes only, and should not be relied on in making any purchasing or investment decision. The information is not a commitment, promise or legal obligation to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described for our products remains at our sole discretion. © 2026 Cloud Software Group, Inc. All rights reserved