How do you sort a pivot table widget?

Follow
Jacob Cluff

I have a pivot table visualization widget set up. Is there a way to resort the table based on a specific column?

Thanks!

0

Comments

3 comments

Date Votes
  • Joel Stewart

    Jacob pivot table widgets are not sortable. That is a limitation with this widget type currently.

    If you're willing to provide a bit more context about the impact, I'll gladly follow up with our product team to create an enhancement request on your behalf.

    0
    Comment actions Permalink
  • Jacob Cluff

    That would be great. Basically, I find myself wishing I could arrange the results from a pivot table in a more presentable view. There are a few things I'd like to see.

    1. For an example, let's assume I'm running a pivot on Sales reps and the amount of ARR per Sales Stage (Pending, Educate & Evaluate, Closed Lost, Closed Won etc). Basically, I'd like to be able to sort the Sales reps by Closed Won amount and list the reps in descending order based on that one column.

    2. I'd also like to be able to rearrange the columns if possible. In the above example there is an order to the sales cycle. Right now my results are populating according to alphabetical order but not in the correct process order. I guess there is a potential workaround where I could affix a numerical value in front of the column header but I'd like to see an easier option.

    Thanks!

    0
    Comment actions Permalink
  • Joel Stewart

    Thanks for the additional information Jacob. As you described more detail about the use case, I think you may be able to use the Table Widget instead of the Pivot Table Widget.

    Starting in 4.3, we introduced sorting for this type of widget. Here is the documentation link: https://documentation.datameer.com/documentation/display/DAS40/4.3+New+and+Noteworthy#id-4.3NewandNoteworthy-Tablewidgetsorting

    If that doesn't reasonably fit your use case, please let me know and I'll proceed with the enhancement request on your behalf.

    0
    Comment actions Permalink

Please sign in to leave a comment.

Didn't find what you were looking for?

New post