Data retrieval based on priority... Help Me..Check the screen shot attached.

[#1]

can any one help me , how to retrieve the data by priority vise in the expression.

Example: i hav the data

location,Area , customername, Capacity...four columns...

location	area	customer	capacity
chennai			500
chennai	sipcot		800
chennai	sipcot	Avula	400

if my selection is chennai,sipcot,avula then the result set is 500,800 and 400.check the screen shot for refernce.

Attachments:

• Posting.JPG (88.2 K)

[swuehl]

Well, if you have selected chennai in field location, sipcot in field area and Avula in field customer, you should have limited the results to capacity 400 already.

I assume you want to retrieve the value for this line even without any selection in area and customer?

[#3]

Exactly...i need that row alone...

[swuehl]

Maybe like attached?

I created an additional ID field for the records using recno() in the LOAD script, the created a table chart with a calculated dimension:

=aggr(nodistinct if(rangesum(istext(area),istext(customer))=min(total<location> rangesum(IsText(area),istext(customer))), ID), location, ID)

You can hide all columns that you don't want to see.

Regards,

Stefan

[#5]

Thank u,,

verymuch helpful....

Rgds,

Avula.gk