User Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Don’t miss your chance to experience Discovery Summit Europe at our best available rate! Early bird registration through 31 Oct.
  • Graph Builder Toolbar streamlines interactive graphing. Creates shortcuts on Report and GraphBuilder Helpers toolbars. Download and install the extension.
  • JMP will suspend normal business operations for our Rest and Recharge Day on Friday, October 2, 2026.
    Regular business hours will resume on Monday, October 5, 2026.

JMP Wish List

We want to hear your ideas for improving JMP. Share them here.
Choose Language Hide Translation Bar
0 Kudos

Tabulate to work more like Pivot Tables in Excel

Status: Acknowledged Submitted by 2 weeks ago
1 Comment (1 New)

What inspired this wish list request? Tabulate is an extremely powerful platform for dynamically summarizing data.  However, once your data is summarized correctly it hits a wall and become stuck to do much else with it.  It seems the intent of the developer was to have you move it to a data table if you wanted to do further manipulation but this removes all the benefits of it being in tabulate, in that you can use the local data filter, quickly change the table, and highlight rows for different subgrouping (among other things.)  Also, for anyone coming from excel, this feels exactly like a pivot table which then leads to frustration when the amount of manipulation is so limited.

What is the improvement you would like to see? I would like to be able to sort the data inside the platform just like I would be able to if the analysis was made into a data table.  So this would not only be sorting by a single column but being able to sort by multiple columns.  Also, there needs to be the ability to scroll lock the columns and rows for when your table gets larger as well as have the control panel be always visible so allow easier manipulation of the table when it grow tall or wide. Finally, in Pivot tables you can filter the values by either label or value filters and while a lot of this can be replicated with the local data filter there is not the ability to show just a ranking of values, which you have the option of in excel.  If I use the Top 10 function I can just show certain levels by summary statistics from a chosen column.

shampton82_0-1789770057117.png

shampton82_1-1789770167436.png

This would be a very value option to limit items shown but a value other than count of rows.  (this options would also be amazing to have for graph builder as a more flexible function than the current "configure levels" option)

 

Why is this idea important? This would make the Tabulate platform more useful, align with user expectations, and also add a lot of value for use in JMP Live, where it is really the only option for showing line by line data that you can interact with.

 

1 Comment
Valerie_Nedbal
Staff
Staff
Wednesday
Wednesday
Status changed to: Acknowledged

Thank you @shampton82 to have submit this request. We will discuss  those internally.