Making selection/filter from object with Dimension Limit

[rygreene3]

Hello.  I have created a graph reporting object with a dimension limit that displays the top 1 value based on the first expression.  The object is correctly displaying the desired results.  Here's my challenge.  I would like to select just the values that meet the dimension limit criteria.  Normally I would do a select possible, but this captures ALL the values rather than just the top 1 values.  Does anyone know of a way for me to select/filter on just the top values that are displayed in the reporting object?

Thank you very much.

[asinha1991 · Accepted solution]

in the calculated exp of list box you can put something like this

aggr(if(rank(expression in your chart)<=1,fieldtobeshowninlistbox),dimensionsinyourchart(could be more than one))  

use 1 as set identifier in your expression

example

aggr(if(rank(sum({1}sales))<=1,[Category]),[Customer],[Category])  

[rygreene3]

Thank you Asinha1991 and everyone else who replied.  I was able to apply Asinha1991's recommended solution and it worked perfectly!  So very happy.  I hope I can return the favor one day.