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
