PowerPivot Table

[Anonymous]

Hello Everyone, I'm using PowerPivot at the excel (Not on the Desktop App),

What I'm trying to do is to create a PowerPivot table with Data from 2 diffrent tables. I Tried to create a releationship between the tabels with the Seller name, but i got an error message (need a monovalent coulmn).

Thanks Guys!

[Stachu · Accepted solution]

the easiest way is to have 3rd table with all the unique Seller Names and do joins from that table (you can do that in Power Query/Get & Transform in the Data ribbon if you use Excel 2016)

or you could append table 1 & 2 but first adding an identifier column for type of sale

Sale Type	Seller Name	Amount
regular	John	607
regular	Ben	834
WIP	John	503
WIP	Ben	456

[Anonymous]

Hey Stacho, thanks for your comment!

Actually there is a database behind the tables, each database has a lot of sales lines that I agreed to the pivot table. Thats why I'm trying to do that in PowerPivot tool.

[Stachu]

that's perfectly fine, you can still connect to the database and make this kind of changes

best way to do it is with Power Query (so you don't  have to copy & paste anything). If you're using PowerPivot connections then I'd recommend rebuilding them in PQ