I am trying to create chem tables that display Statistics (Max concentration, Min concentration, Average concentration) for each location in our filter.  It seems like the Statistics options in the Table settings apply to the entire dataset (all locations), which isnt very helpful if you are assessing a large dataset with different locations/ varying results (ex: the alkalinity concentration may be very different at each location, so the average of all locations isnt a beneficial measure).

Is there an option to look at these statistics by location?  Or does these calculations all have to be done in excel after exporting?

I can provide screenshots if it helps.