Create count analysis like excel pivot

Hans_Hsu — Sat, 10 Jun 2023 23:27:52 GMT

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?

Re: Create count analysis like excel pivot

txnelson — Fri, 26 Mar 2021 03:58:09 GMT

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

Go to pull down menu Tables=>Summary
Select the Volume column from the Select Columns box and click on the Group button to add it to the Group selection
Click on OK

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