To do aggregations in new tables, you can either use tabulate in the Analysis menu or Summary tables. Personally, I do these operations in Graph Builder most of the time.
To keep everything in one table, unlike Excel, your calculation will be created in a new column entirely.
- To sum a number of X, you can use either Col Sum() for totalizers or Col Cumulative Sum() for counters. You can create a new column with only ones as numbers to sum [1,1,1,1], or put it directly in the formula.
Here I am obtaining the year from a date column and counting how many rows I have (in total or accumulated).
![FN_0-1681997647875.png FN_0-1681997647875.png](https://community.jmp.com/t5/image/serverpage/image-id/52115iCA0661D8808A1726/image-size/medium?v=v2&px=400)
The file is attached.