Filter count matrix

[c_c]

I am creating a matrix that contains two values -

1) Count of apples (by each location)

2) Average of prices per apple

I am trying to filter out of the matrix the ones which show 3 or less count of apples for every column location...
It looks like the filter only does it for the column totals but not the rest of the matrix. Any suggestion on how I can get the filter to work for all rows/columns instead of just the total? Thank you!

[v-sihou-msft]

@c_c

For your requirement, you just need to add Visual Level Filter, it will filter data at cell level. See my sample below:

Regards,

[c_c]

Thank you so much for taking a look at my inquiry.

The problem is that I have several columns within the matrix and it only filters the values on the total. So for example below, these are all the average prices that is presented in the matrix. I don't want to show any of the prices that have a count of apples less than or equal to 3. So when I do implement the visual filter as suggested, it ONLY filters the total column average. Not the counts that are of the locations. Thanks in advance for any insight on this!

Average apple prices by count by location:

                      Washington            Boston               New Hampshire                  New York                        Total

Fuji               :     $6                         $3                              $5                                   $2                               ~$XX

Machintosh  :     $3                         $8                              $2                                   $8                               ~$XX

Green           :     $9                         $2                              $1                                   $10                             ~$XX

Honey Crisp :     $2                         $10                            $6                                   $9                              ~$XX