Store possible values of listbox into different variables

[gauthamchilled]

How can i store the pssoble values of listbox in different variables.

PFA,

I want the variables to use in a chart dynamically

[ToniKautto]

The aggregation function will target your current data set, which include both selected values and possible values. A list box shows the values in a field, so by using Concat() you can concatenate all values in the field. For example =Concat(DISTINCT Month, ',') gives you a comma separated list of the filed values.

I am very unclear on why you want to store each value in separate variables. What is your use case with that?

You can pick a specific value from the list by using a function that allows indexes. For example =Max(Month) or =Max(Month, 1) returns the largest value, while =Max(Month, 3) gives the third largest.

[gauthamchilled]

Toni,

Thanks for the reply. Max(Month,1) returns  3 here not the month name.

[gauthamchilled]

i guess i have to use maxstring() but still Maxstring(field,1) not workin either

[tresesco]

For 3rd min value you can try like:      =FirstSortedValue(Month, Aggr(Month,Month),3)