cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Browse apps to extend the software in the new JMP Marketplace
Choose Language Hide Translation Bar
Hans_Hsu
Level I

Create count analysis like excel pivot

In this file, each row has its own volume value, I would like to have a summary table showing that:

volume = 1,  239 counts,

volume = 2,  201 counts

volume = 3,  92 counts

.....etc

 

How to make this kind of table?

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: Create count analysis like excel pivot

  1. Change the modeling type for your Volume column to Ordinal
  2. Go to the pull down menu        Analyze=>Tabulate
  3. Drag column Volume to the Drop zone for rows

volume1.PNG

If you want the data in a data table, just click on the red triangle and select Make into Data Table

OR

  1. Go to pull down menu      Tables=>Summary
  2. Select the Volume column from the Select Columns box and click on the Group button to add it to the Group selectionvolume3.PNG
  3. Click on OK

volume2.PNG

I encourage you to take the time to read the Discovering JMP document under the Help pull down menu

Jim

View solution in original post

1 REPLY 1
txnelson
Super User

Re: Create count analysis like excel pivot

  1. Change the modeling type for your Volume column to Ordinal
  2. Go to the pull down menu        Analyze=>Tabulate
  3. Drag column Volume to the Drop zone for rows

volume1.PNG

If you want the data in a data table, just click on the red triangle and select Make into Data Table

OR

  1. Go to pull down menu      Tables=>Summary
  2. Select the Volume column from the Select Columns box and click on the Group button to add it to the Group selectionvolume3.PNG
  3. Click on OK

volume2.PNG

I encourage you to take the time to read the Discovering JMP document under the Help pull down menu

Jim