Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
use an expression based listbox on the other sheets
Aggr(only({< Region = {'list of regions here'} >} Region), Region)
or please post a sample
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.