Pivot Tables for Scientific Data?

[resinguy]

Does it make sense to use Pivot Tables for scientific data where I'm not looking to auto sum various data streams? I generate weekly reports showing trend data based on 1 to 5 minute interval data slices, typically in cluster charts (for instance, water flow rate vs. time). There are some metrics that I would like to calculate, but none of them involve summing data.

 

[SpillerBD]

Maybe you'd be interested in this example of PowerPivot.
https://powerpivotpro.com/2012/02/peak-detection-a-surprising-usage-of-powerpivot/

I think there are several different concepts you might use, even without going through PowerPivot.