Hi there,
Is it possible to create one pivot table from 2 different sets of data?
I have some 1,500 customers (each on different pricing levels) and around 90 products. Ultimately I would like to be able to generate pricelists for each customer group (or by distributor) using the 'show report filter pages....' option under pivot table options.
Hope that makes some kind of sense! I can send a dummy file that may help explain better (cant find how to attach it!!!)
Hopefully there's a guru out there that can help! Many thanks.
Is it possible to create one pivot table from 2 different sets of data?
I have some 1,500 customers (each on different pricing levels) and around 90 products. Ultimately I would like to be able to generate pricelists for each customer group (or by distributor) using the 'show report filter pages....' option under pivot table options.
Hope that makes some kind of sense! I can send a dummy file that may help explain better (cant find how to attach it!!!)
Hopefully there's a guru out there that can help! Many thanks.