For f i wanted to use filters specfic to that tab in a document, how can i do that?
I have mutiple tabs and, say if i apply a filter on prodcut , i dont want that to be applied fro the other tab,
You can use alternate state as suggested by tres, or you can set triger
on sheet properties--> trigers --> add action --> select in field --> choose the field you want to clear
and leave the search string empty (you can also put null())
Well, here is how you do it:
Document Properties --> General --> alternate states --> Add a state for each sheet
Now in each selection field on each tab go to properties and you will find alternate state in general tab. Sett all objects in the sheet to the sheet alternate group.
See attached example
If this is too much work then I suggest you use the other option I suggested.