Forum Discussion
MS2121
5 years agoRegular Visitor
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
- AnonymousNot 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