Forum Discussion
Matrix table with heirarchy columns doesnt filter properly with slicer
Hi Team,
Lets suppose I have 3 countries and 4 products spread across countries as below -
| Country A | Product 1 |
| Country A | Product 2 |
| Country A | Product 3 |
| Country B | Product 2 |
| Country B | Product 3 |
| Country B | Product 4 |
| Country C | Product 3 |
| Country C | Product 4 |
I have a product slicer And a matrix table with heirarchical columns as Country --> Product.
When I filter on slicer as Product 2, the matrix table should give the result as
| Country A | Product 2 |
| Country B | Product 2 |
BUT it gives the result as
| Country A | Product 1 |
| Country A | Product 2 |
| Country A | Product 3 |
| Country B | Product 2 |
| Country B | Product 3 |
| Country B | Product 4 |
All occurences of filtered countries are appearing. Anyway to restirct the matrix table visual to show only the items with Product filtered and NOT all occurences?
Thanks in advance
Hi mohd_k52 ,
According to your description, you need to put the product field in the value area. Refer to the following result.
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
amitchandak if you have any idea, kindly suggest
v-henryk-mstfCommunity Support
Hi mohd_k52 ,
According to your description, you need to put the product field in the value area. Refer to the following result.
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
