Hi all,
I have a list of products in one column, then some other data and lastly the column where is the project associated with that product. This is then going to pivot table to be able to see all products in one project when I filter on it.
However, some products are applicable in more then one project and I would like to see product A when I filter on project 1 but also to see it when I filter on project 2. Is this something a pivot table can do?
Thanks
I have a list of products in one column, then some other data and lastly the column where is the project associated with that product. This is then going to pivot table to be able to see all products in one project when I filter on it.
However, some products are applicable in more then one project and I would like to see product A when I filter on project 1 but also to see it when I filter on project 2. Is this something a pivot table can do?
Thanks