OLAP Functions Db2 for i: Gimme some more !

Does anybody remember “1, 2, 3 ,4 gimme some more ” by DDSound , was 1978 and I was a child …

When I tried to use DB2 for i OLAP functions to make a simple ABC Analysis (Pareto) I found out that OVER() work only with ROW_NUMBER(), RANK() and DENSE_RANK(), if I need a SUM() or AVG() or something else I can’t use OVER() !

“Hey Rochester, Gimme some more !”