how to filter field value based on another field value
I need to hide the row where field1=0 and field2 =0. but if the user want to show all then i want to show all but if any one field is 0 then it should bot hide. how can i implement this.
SN
Field 1
Field 2
1
0
0
2
0
124314
3
13242134
0
4
0
0
5
452345245
23452345234
6
3452345
23545
Show ALL
Here i want to see row 2,3,5and 6
Where ever both fields are 0 then only hide. if any one field 0 then it should display. if I clcik on Show all then it will show all the records.
if i click hide then it will hide where field1=0 and field2=0
