Forum Discussion
Multi level pivot table
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 Replies
- 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
- 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.
