Aggr Help?

[#1]

Hi,

I am trying to use the Aggr function for this example.

ID	Group	Transaction	Paid	Outstanding
1	a	1	0	10,000
1	a	2	1,000	9,000
1	a	3	8,000	1,000
1	a	4	250	750
1	a	5	100	650
1	b	6	0	12,000
1	b	7	6,000	6,000

What i am trying to find out is the total outstanding for each ID. In this example the Total for ID 1 would be the sum of the Latest Outstanding (Latest Transaction) per group and ID. Total outstanding for ID 1 would equal 6,650.

Could anyone explain to me how i would use the Aggr function to work this out.

Thanks in advance.

Kind regards,

Natalie

[kaushiknsolanki]

Hi,

    Have a look at the application.

Regards,

Kaushik Solanki

[#3]

Can u tell me ur table structure and all fields?

Regards,

kabilan K.

[#4]

Hi,

Thanks for your response. I'd ideally like to be able to do this in the chart so i am able to look back in time over different periods.

Is this possible?

Kind regards