Pivot table (aggregation for the multiple dimension)

[#1]

Hello,

How I can achieve the following?

Thanks

[kaushiknsolanki]

Try this expression.

sum(total <vari_code>Aggr(sum(x)/sum(y),vari_code,no))

Regards,

Kaushik Solanki

[#3 · Accepted solution]

I found it

sum(aggr(nodistinct

                              sum(x/y)

,vari_code))

[#4]

I prefer to simplify the expression. Try:

     Sum(TOTAL <vari_code> x/y)

And use 0 as the Null symbol to show 0 instead of null default symbol.

[jolivares]

Try this....

Aggr(NODISTINCT Sum(x/y),vari_code)