You can also try tabulate:
![jthi_0-1636800460388.png jthi_0-1636800460388.png](https://community.jmp.com/t5/image/serverpage/image-id/37542i24C1D3C526CD721F/image-size/medium?v=v2&px=400)
you can turn it to datatable from red triangle menu:
![jthi_1-1636800560998.png jthi_1-1636800560998.png](https://community.jmp.com/t5/image/serverpage/image-id/37543i87FFF71DADB359ED/image-size/medium?v=v2&px=400)
![jthi_6-1636800837997.png jthi_6-1636800837997.png](https://community.jmp.com/t5/image/serverpage/image-id/37548i6AD892C8DEE7CB4C/image-size/medium?v=v2&px=400)
With Summary table you might need to do some extra calculations either before or after creation of the Summary. Below is example doing them after:
![jthi_2-1636800665443.png jthi_2-1636800665443.png](https://community.jmp.com/t5/image/serverpage/image-id/37544i8B0B3D097110ECD1/image-size/medium?v=v2&px=400)
Select either N Rows and either N(Green) or N(Red), right click on selected column and create new formula column:
![jthi_3-1636800728993.png jthi_3-1636800728993.png](https://community.jmp.com/t5/image/serverpage/image-id/37545i6A45D6014F793ECE/image-size/medium?v=v2&px=400)
Table after sorting, additional formulas and formatting:
![jthi_5-1636800808787.png jthi_5-1636800808787.png](https://community.jmp.com/t5/image/serverpage/image-id/37547iA859484FBEFC6182/image-size/medium?v=v2&px=400)
-Jarmo