Multi level pivot table

[jana_d]

Hello everyone,

I have a long list of products where each of them has a project assigned in the cell next to it. I then have some pivot tables filtered to the project so I can see only products related to that project. 

The issue is that some product are relevant to more than one project and I would like them to be visible. So if I have product 1 that is used in Project A and Project B I'd like to see Product 1 when I filter on Project A but also when I filter on Project B.

Is anyone able to help with this? Thank you

[#2]

i suggest to put the product in the row at first level, then put the project, this way your product will be unique & you will see which product is available in other projects

[#3]

I am not sure I understood this properly. Each product is already unique but can be assign to more than one project. I am looking for a way to have all project from one product have in the filter of the pivot table.