question

[userid128223]

From - PostalCode	From- City	To- PostalCode	To- City	Days
M1P	xyz	M1H	ppt	2
S1Q	yyz	M1H1KT	pps	5
T1P	tyz	P1T1QG	yts	4
M1H	abc	P1T	yms	1

Lets say i have above table. and i have selector for each field. How can i show chart that will do the following.

When user selects From Postal Code & City. Then picks To Postal Code it takes higher # of days at first 3 digit of To-Postal Code level.

Results Example

From - PostalCode	From- City	To- PostalCode	To- City	Days
M1P	xyz	M1H	pps	5

[sinanozdemir]

Hi,

Let me know if this is something you are looking for:

I am attaching the qvw file as well.

Thanks

[userid128223]

yes. i don't see any solution.

[sinanozdemir]

Can you explain why you don't see any solution?

Isn't the point to show the attributes of the postal code that has the highest days?

[Peter_Cammaert]

Not entirely. I guess the request is somewhat different. Whenever a single From Postal code and/or From city is selected, the first three corresponding colums are displayed, together with To-city and Days from the row that has the same first three characters in To-PostalCode and the highest number of days. Not too simple.

Peter

[userid128223]

Thanks Peter. You have the understanding correct. Thx Sinan for an attempt.