Grouping by different Dimension in script

[prathipsrinivas]

Hi All,

I could really use your technical expertise here.

The requirement is to sum the values of Maximum transaction of Max Entry Date for particular Currency in a Particular policy.

I would understand I need to implement it by group by using Entry date, transaction, currency, policy.

But it was not giving expected results.

Any ideas how to implement this?

Thanks,

Prathip

[swuehl]

Could you give some sample records and your expected result of how to sum the values?

[Anil_Babu_Samineni]

You can use Directly like

Load Field1, Field2, .., FirstSortedValue(Transaction, -[Entry date)) as Max_Transaction Group By Field1, Field2...