Oracle Analytics and AI

DNK

Code	sum	alternate Sum
xyz	5	14(Sum (abc+pqr))
abc	8	11(Sum(xyz+pqr)
pqr	6	13(Sum(xyz+abc))

Hello Friends,

I have a pivot table like above. Now I need to calculate the Alternate Sum for the above table in the following way

for the Code xyz Alternate Sum = Sum(abc+pqr+.....)

for the code abc Alternate Sum=Sum(xyz+pqr+.....)

for the code pqr Alternate Sum= Sum(xyz + abc+.....)

There may be additional Codes as well in the Code field.

Thanks for your help.

DNK

Gianni Ceresa

Hi,

Isn't it a simple sum at the total code level minus the actual value if sum ?

So code is part of an hierarchy, you use aggregate at the parent level and then subtract the value for the current row.