Running Total & Sorting

Bonediggler

Experts!

Does the Running Total tool automatically sort data by the values selected to Group By?  I know this happens with the summarize tool but it doesn't seem to be documented.

If so, it would be unnecessary to sort the data before sending it through the Running Total tool - correct?

Thanks in advance!  

mceleavey

Hi @Bonediggler , Outstanding name. Fine work.

In short, yes. The Running total tool uses whatever order you have in the data when it goes into the tool, and will create a a running total of a given column(s) from row one down, taking into account the grouping function.

If you don't use Group By, it will start on row 1 and simply create a running total.

If you use the group by, it will then create the groups by that field, sorted as they are, then do the same.

M