Forum Discussion

MS2121's avatar
MS2121
Regular Visitor
5 years ago

Matrix slicer

Hi

 

I have a matrix with customer names (rows), product categories (columns) and sales numbers (value).

I would like to add a slicer for the categories. When I select product category A, I want to see all the customers with sales numbers greater than 0 in category A

AND

their sales numbers in the other categories.

 

With the standard slicer I can only see the customers with sales numbers greater than 0. The other categories disappear.

 

Is there a way to prevent that the other columns disappear when I use the slicer?

 

Thank you very much in advance!

 

 

 

 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    HiMS2121

     

    I'm not quite sure I clearly understand your needs. Share your sample data and expected result to me if you don't have any confidential Information.

     

    Best Regards,

    Caitlyn Yan