Can we use nested aggr

[#1]

I have written an aggr(sum(distinct salary),SKILL_NAME,EMP_ID,YEAR,MONTH) ). Now I want to do

an aggregation of the sum we got in the above aggregation, based on SKILL_NAME AND EMP_ID. To make it clear, lets assume the sum we got in first aggr as SUM1.

So I want aggr(sum(sum1),SKILL_NAME,EMP_ID). How can we do this.

Thanks in advance.

Regards

Santhosh.

[juleshartley]

It seems that the main reason that  you are doing this is so that you have a distinct monthly sales figure by Emp_ID and skill... so perhaps worth creating a monthly sales table in your data model?

[tresB]

Yes you can.

Aggr(Sum(aggr(sum(distinct salary),SKILL_NAME,EMP_ID,YEAR,MONTH) ) ),SKILL_NAME,EMP_ID)  - I guess, it's a valid one. Have you tried? Isn't it working?