Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to exclude a field value using action

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.

3 Replies
vinieme12
Champion III
Champion III

use an expression based listbox on the other sheets

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
vinieme12
Champion III
Champion III

or please post a sample

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Not applicable
Author

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.