Equivalent to Analytical function of oracle Syntax at script level

[sunil1989]

Hi All ,

I have data at location,item and at day grain but in Ui i have to show the region average and loop and reduce at location level.

but when we are going to loop and reduce at location level , i cannot calculate the region average , thats need to be done at script level.

Do we have any function at script level that we can aggregate the value at region level for e.g in oracle we can use analytical function like SUM(sal) OVER (PARTITION BY deptno)

[sergio0592]

Hi,

And if you try in your preceding load statement :

load

sum(sal),

Dptno

resident SALES

group by Dptno ;