Spotfire Ideas Portal
Add a new idea Subscribe
Status Already exists
Product Spotfire
Created by Guest
Created on Jul 10, 2019

RELATED IDEAS

Sorting with multiple columns

Hi,

If I add multiple columns in a cross table the sorting doesn't work. All my rows are sorted alphabetically and within the hierarchy it is sorted the way I want. What I want is if I have a cross table in which there are 3 columns. Column A, Column B and Column C. 

Column A and B are dimensions and Column C is a measure. My aim is to sort the table is descending order based on C. If I remove B it works but If i add column B it doesn't work and it gives me alphabetically sorting on A.

Ideally it should it should preserve the hierarchy and instead of giving me the result alphabetically it should sort on decreasing/increasing value of C

  • Attach files
  • Admin
    Niklas Amberntsson
    Reply
    |     Mar 4, 2020

    Hi Tauseef, I might have misunderstood, but it looks to me this is already possible. See below screenshot; by (left) clicking on the column Class Sales you can open the popover and select how to sort (globally or within the hierarchy). Let me know if this is not what you are looking for.

    image.png
    image.png
    Open full size
    image.png
This document (including, without limitation, any product roadmap or statement of direction data) illustrates the planned testing, release and availability dates for Spotfire products and services. It is for informational purposes only and its contents are subject to change without notice. Planning to implement - generally 6-12 months out. Likely to Implement - generally means 12-18 months out. Copyright © 2014-2023 Cloud Software Group, Inc. All Rights Reserved. Cloud Software Group, Inc. ("Company") follows the EU Standard Contractual Clauses as per the Company's Data Processing Agreement. Terms of Use | Privacy Policy | Trademarks | Patents | Contact Us