1. Look at function FirstSortedValue() - it will help you with the first problem.
2. You can use Calculated Dimensions to limit only Cities with cetain condition. For example:
- Define a Calculated Dimension with the following formula:
=if(No > 1, City, null())
- Check the checkbox "Suppress when Value is Null".
As a result, all Cities that don't fulfill your condition, will return Nulls and therefore will be suppressed.
As a recommendation for future posts - try to express your question in the body of the message and not in the attached application. Most people won't download the application before they know what the question is about...
Thanks a lot for your answer... OK for your recommendation.
Two "problems" are still remaining : - firstsortedvalue is not able to take expressions into account (sum) - Suppress when value is null is not available on expressions.
Application herejoined is detailing the matter : I would like to see the first sorted value of data that are representing more than a certain amount of a global total.
