Force selection about dimension values based on result expression

[#1]

Hello,

I need froce filter about a field (Automatically). The values that will be selected on field, would be the same values that I have in a dimension in a straight table. The dimension, only show values based on a expression result.

How can i pass or convert the values of dimensión to a selected values in a field??

Thanks!!

[mohamed_ahid]

may be a trigger can help .

can you post a sample file ?

[satishkurra]

Go the sheet properties --> Triggers tab, click add action and select Action type as Select in Field, provide field and name.

Thanks

[Anonymous]

Yes, trigger can help.  It will be action "select in field".  The question is about "search string" of the action.  It has to select the values per table rules, which we don't know.