Not quite yet. What I need is an output like this.
10001 1372679 2 0
1416460 1 1
1491820 3 1
1783672 4 1
1866327 1 1
1941486 1 0
That would show 4 different changes in order counts across sales orders.
I would then take THOSE totals per patient to find the average changes per patient.
The 1/0s are to show when the next SO has a different count from the previous SO
Thank you so much! That did the trick. Do you know how to get calculated fields/table calcs to appear in Grand Totals from the analytics tab? Do I need to do a WindowSum and create my own field?