Showing the particilar value of Field in table

[Vinay39]

I have a dimension "Status" it has Closed, Open, Pending as options 

condition is like when i open the sheet it should show only Open values and if i use filter pane to see other options the table show the other details

[justISO]

Hi, maybe sheet actions can help in this case?:

[Vinay39]

If i use filter to look for other Option does table show the remain options

[justISO]

This action set 'Status' field to 'Open' when you open sheet. In other words it filters 'Status' 'Open', but everything else still remains - you just don't need to set it manually everytime when you open sheet. If you want other options, just filter them out with the same filter and table will show them.

[Vinay39]

Thanks it worked 👍