Matrix Table Total Row not calculating right totals

Hi,   Because some of the rows are not applicable based on the filter value, it does not show up in the matrix table. However, the total it displays at the bottom includes those missing data points...