Show and filter 3 matrix from a slicer

[nicolast29]

Hi

I have 2 main category (total FRAIS & TOTAL SEC) with for each 3 sub category

I want to dynamicly when i select one of the main category , show the data of each of the sub catgory one per matrix

For example if i select the category Total SEC, i want that :

- the first matrix show only data from the first sub category : epicerie

- the second matrix show only data from the second sub category : Liquide

- the last =matrix show only data from the third sub category : DPH, as show in this example

And if i select the second main category TOTAL FRAIS the data will show:

- the first matrix show only data from the first sub category : Charc ls

- the second matrix show only data from the second sub category : Cremerie

- the last =matrix show only data from the third sub category : Surgele

I didn't arrive to find who to do it

I precise that the data in the file below are special and very simplify as i cannot send the original file

I really want 3 Matrix and to select only the main catgory (by a slicer )

thanks a lot, Nicolas

https://1drv.ms/u/s!AoqtZHsX4BzvhLIMsQUPV8SkEksQMQ?e=f9x0Nf

[lbendlin · Accepted solution]

Why go through all that when you can get the functionality for free, wiht the standard slicer annd matrix?

[nicolast29]

So beautifull and so simple

Thanks a lot

Have a nice day 👍

[nicolast29]

yes i know , choice of presentation of the client 😎