How does one have predefined filter on whole sheet?

[dwighttrumbower]

I would like to show only certain products on a sheet.

I have several objects on the sheet and need to exclude a few of the products. Is this easily done?

Thanks

[canerkan]

Hi Dwighttrumbower,

i haven't done it yet but i found a video on youtube. It seems pretty simple.

https://www.youtube.com/watch?v=d85WIgy35Ig

Regards,

Can

[dwighttrumbower]

Thanks I was able to do it with a default bookmark.

[stevejoyce]

My thoughts:

-Have an action on opening your sheet to select your "certain products".  

-Variabilize your common sheet set analysis (vSheetCommonFilter = [Product] = {'ABC', 'XYZ'} and use this $(vSheetCommonFilter) in all of your objects' expressions.

-Create a secondary product field with just the values you want to show on this sheet.  Use this dimension in your sheet's objects.  But you'll have to keep in mind excluding the real product field so there is no unexecpted conflict

I would probably go with (2) but depends on UX.