It seems to me that list of the secondary datasource fields are unavailable while filtering i.e using Top condition.
Thanks for the response. Can you pls explain with an example, how I can do this?
One way to do this would be to sort the dimension based on the secondary measure, so that the dimension is in the desired order. Then, create a calculated field similar to the following (in your primary data source):
Place this calculation on the filter shelf and select True.
Hope this helps!
Thanks for the response. As you said I tried sorting the dimension based on the secondary measure.. but my bad, the seconday measure is not there in the Sort by field list.
Kindly suggest any other workaround to solve this.