Filter a list by a selector

Question

I have a page that has a list of sellers and a list of accounts. The list of accounts module has a line item of the seller. Is there a way to set up a filter with the accounts card to filter out accounts when I select a specific seller?

Sai_Bharadwaj_Venati · Answer

@wld002 you can put a direct filter in the view published on dashboard.

* create a filter line item with dimensions of Account and seller
* update formula as item(seller) = account.seller

wld002 · Answer

@MayraS I didn't want to add a line item selector in addition to the native page selector. My end users will overlook that and I can filter the grid itself which will work the same. Was hoping to be able to use the native page selector and logic in the module I need to sync all the grids.

MayraS · Answer

Hi,

* You can create a line item selector for the seller (list formatted) in a new module

* make a filter line item (boolean formatted) against the account. formula logic should look something like:

seller line item in the account module = line item selector

* try select one of the seller in the line item selector and see if boolean is ticked as expected.
* apply the filter to your module / context selector as needed
* publish the line item selector to the page.