Forum Discussion

c_c's avatar
c_c
Frequent Visitor
8 years ago

Filter count matrix

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 coun...
v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
8 years ago

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's avatar
c_c
Frequent Visitor
8 years ago

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