Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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?
Exactly...i need that row alone...
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
Thank u,,
verymuch helpful....
Rgds,
Avula.gk