Create count analysis like excel pivot

Hans_Hsu

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?

A12-new.jmp

txnelson

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

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 selection
3. Click on OK

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