Forum Discussion

raina's avatar
raina
Frequent Visitor
3 years ago
Solved

Filtering matrix by total

Hi,

can anyone help with filtering the matrix. I should filter out of the companies whose total sales (period 1+2+3) <1000. In this case, companies 1478 and 1490 should be hidden.

 

 

Let me know if you find a good solution.

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    raina , try a visual level filter on your measure that should work in that case

     

     

    • raina's avatar
      raina
      Frequent Visitor
      3 years ago

      amitchandak 

      Thanks for the reply. I thought I tried that already, but apparently not. Only problem is that the visual level filter seems to make matrix really slow, is there anything I can do about it?