Using GetFieldSelections() to return available values from a field after selections are made in another field

[mikegrattan]

I'm wondering if it's possible to use GetFieldSelections() in the following way:

• I have a 'flag' dimension that is set up in the data load script as: if(date(date#("CLDATE",'MMDDYY')) >= Today()-28,1,0) as Flag_PastMonth
• When I select Flag_PastMonth = 1 in a sheet, there may be more than one YearPeriod represented, such as 2024-8 and 2024-9.
• I would like the function GetFieldSelections("YearPeriod") to return 2024-8 and 2024-9, but since these values are not actually selected, it returns nothing.

Thank you for any advice.

[marksouzacosta · Accepted solution]

Hi @mikegrattan 

What about using something like:

=Concat([YearPeriod],',')

Regards,

Mark Costa 

[mikegrattan]

I tried Concat but got repeating values. However, Concat(distinct YearPeriod,',') works fine.  Thanks.