I have what would appear to be a simple issue totaling filtered data as below

Dept count
NESAS 1
NESAS 1
blabla 1
3

Rate 22
Total 66
How can I get the above to work when I filter the data? For instance if I
filter by the code NESAS the sum should equal 2 NOT 3 and this would then
give total of 44