Tables / Scripting

[#1]

I have data which looks similar to this.

Plant	Store	City	Vehicle	Freight	Valid_from
P1	S1	C1	V1	100	01.Jan.14
P1	S1	C1	V2	75	01.Jan.15
P1	S1	C1	V1	50	01.Jan.15
P2	S2	C1	V1	75	01.Jan.15
P2	S2	C1	V2	100	01.Jan.14

I need to take the "Freight" for a combination of "Plant", "Store" and "City" ("Vehicle" not required)

That "Freight" which has latest "Valid_from" and which is the Maximum in case of repetition.

For eg:

In the above scenario, for P1 - S1 - C1, there are 3 freights.

1st is valid from 01.Jan.2014 while 2nd and 3rd from 01.Jan.2015.

Among the last 2, there are 2 different Vehicles V1 and V2. I need to take the Maximum of the two .i.e., 75.

Any help is extremely appreciated.

Regards

Raghav

[Gysbert_Wassenaar]

See attached qvw

[francoiscave]

Hi Raghav,

See the attached file to get the solution.

Best Regards,

François

[francoiscave]

Hi Ragghav,

Have you find a solution ?

If your are satisfied by a response, please mark it as correct or helpful to close this tread.

If not, how can we help you?

Thanks,

François

[#5]

Hi François,

Thanks for your reply. But I still am to access my system. Will reply as

soon as I check please.

Thanks again for your immediate response

Regards

Raghav