I'm not even sure about how to word this question so I will try my best.
I have the following situation. I am trying to make a pricelist for products which have multiple identifiers, but have it cover multiple customer locations.
I'll try to explain.
My table look like this:
|Product ID1 ||Product ID2 ||Product ID3||Customer1||Customer2|
Data Data Data Price1 Price2
What I want to do is to create a PivotTable from this data and have it laid out so that the product details are in the Row Columns. I would like to put something into the filter area so I can filter the customer to only display their pricing for each product. The only way I can think of doing this is by repeating each product for each customer down the table, which I would rather not do if possible.
If anyone could help, it would be appreciated.
I have the following situation. I am trying to make a pricelist for products which have multiple identifiers, but have it cover multiple customer locations.
I'll try to explain.
My table look like this:
|Product ID1 ||Product ID2 ||Product ID3||Customer1||Customer2|
Data Data Data Price1 Price2
What I want to do is to create a PivotTable from this data and have it laid out so that the product details are in the Row Columns. I would like to put something into the filter area so I can filter the customer to only display their pricing for each product. The only way I can think of doing this is by repeating each product for each customer down the table, which I would rather not do if possible.
If anyone could help, it would be appreciated.
