Statistical Calculation in E1 UBE

Hello

I have a requirement to calculate the Statistical Mean, Median, Mode and Min, Max, Last values over a range of quantity fields F4311.PQOR  within a UBE.

Max, Min, Mean and Last were simple to do using a Lvl Brk Footer and aggregation and PC value assignment.

However, calculating the Median and Mode is seemingly a challenge.

I know that it can be achieved by using a temp table to insert/update and then sort and read it back for Mode and similarly for Median do the calculation manually.

But I want to avoid this as this would create performance issues as this an hourly update UBE.