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 rela...
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.