Hello,
I have created one straight table from below table which contains some entries as NA and I want to hide those entries in table.
| A | B | C | Sum |
| South | NA | NA | 99687 |
| West | Laptop | OnlineSearch1 | 89687 |
| South | NA | NA | 89657 |
| East | Laptop | OnlineSearch1 | 139657 |
| East | Kiosk | NA | 239657 |
| West | Mobile | OnlineSearch2 | 539657 |
| East | Laptop | NA | 999657 |
| North | Ipad | NA | 39144000 |
| East | Ipad | NA | 0 |
| South | NA | NA | 99687 |
| NA | Mobile | NA | 0 |
I am to hide those entries by using this expression =if(DRILL1<>'NA',sum(total),0) but the issues is total coming out is wrong. Total is considering the hidden rows as well.
Attached the application and data file for your reference
