PowerPivot Help

[gavs73]

Hi, I'm quite new to PowerPivot, and would appreciate advice on how I can get a single column for 'Stock' when combining my 9 Regional Data Tables.

I created Table 10 which has the Unique ShipTo codes to link customers together, and Table 11 which has the Unique Product Hierarchy codes, but when I bring 'Stock' into my Power Pivot Table it creates a new column rather than combining under the single Hierarchy code.

Thanks in advance for any help.

Gavin

 

[scottsen]

Pictures didn't worky.

 

[gavs73]

 

[gavs73]

 

[scottsen]

If there is any way you can combine those tables BEFORE you get to Power Pivot, your life is going to improve greatly. Power Query would be the default answer here.