Show the selected field Max date Value

[princyal]

Hi,

I have Fund field and Assets Field .When i  select Date field  i want the  fund field max date and sum(Assets).

eg :

suppose i select fund 3 i want the max date of 30/11/19 sum(Assets)

i attached my sample data

please help any one as soon as possible

thank you

[princyal]

Ok , thank You

i am waiting for the positive answer

[sunny_talwar]

positive answer?

[princyal]

I am waiting for the positive reply.

last two days i am working on this requirement i asked many people no one can solve this problem

Now for me  your the only hope for me to solve my problem 

[sunny_talwar]

I want to help, but I need to understand what you are doing? Can you provide the output for the above set of data that I provided?

[Rodj]

@princyal I fear we've missed your deadline for getting this worked out. Despite best efforts we haven't had enough information on the challenge you are facing to be able to help by the looks of it. As per Sunny's reply, if you still want to resolve this we just need some more detail on exactly what your data looks like and what you trying to achieve.

[princyal]

Hi,

Again I attached my sample data. This is my actual data format So much data only even I received, the client requirement is

 If I selected 30/09/19 I would just sum the first 3 records for Fund1,fund2, Fund3 (8000+10000+7000)

So, if I select Reportdate=30/11/209, I would get the sum of assets marked in yellow colors are 

if  I select Reportdate=30/12/209 on that Fund4, Fund5, Fund 6 is repeated again (10000+15000+20000-5000+5000+10000)

[princyal]

hi ,

This Is My Actual Data so much data only we received from client

[ravi200351023]

try this one

AAA:
LOAD [Check No],
Report_Date,
Fund,
Assets
FROM
[111.txt]
(txt, codepage is 28591, embedded labels, delimiter is '\t', msq);

Temp:
load
[Check No],
Report_Date,
Fund,
Assets,
numsum( Assets, Peek( 'Bsum' ) ) as Bsum
resident AAA order by
Report_Date,
Fund;

drop table AAA;

output: