Matrix table with heirarchy columns doesnt filter properly with slicer

[mohd_k52]

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

[v-henryk-mstf · Accepted solution]

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.

[mohd_k52]

@amitchandak if you have any idea, kindly suggest