Aggr function usage.

[colliers_sn]

Hi

I have attached the QVW file and the Sample data file and my request is in the QVW.

Any help is highly appreciated.

Thanks much.

[sunny_talwar]

Can you specify what your expected output is?

[colliers_sn]

Lease ID 446 should show Exp*Frequency amount for subspace ID 669 as that is the highest amount compared to subspace ID 510.

Thank you.

[sunny_talwar]

What that amount needs to be? I am looking for a number I should be aiming for?

[colliers_sn]

36,247 whIch is sum of Exp*Frequency for 610

[colliers_sn]

I mean 669 *

[settu_periasamy]

Maybe like attached?