Total is coming out to be wrong in case of hiding a row in straight table

[#1]

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

[sunny_talwar · Accepted solution]

Try this expression:

=Sum({<$(='['&GetCurrentField([DRILL1]) & ']') -= {'NA'}>}total)