How to exclude a field value using action

[#1]

Hi All,

I have scenario like,

I am navigating from one sheet to another.

Main sheet populating 20 values in region field.

while navigating from Main sheet to another sheet there i need to populate only 18 values in the region field.

How to exclude the field values by using action.

[vinieme12]

use an expression based listbox on the other sheets

Aggr(only({< Region = {'list of regions here'} >} Region), Region)

[vinieme12]

or please post a sample

[#4]

Thanks for your reply Vineeth,

I need to show those region values not only in a list box also in table box.

So while navigating from main to that table sheet in the table box also need to exclude those 2 values.

I am preparing the data.