Forum Discussion
Solved
Power Pivot join with pivot table
I've used complex Power Pivot models routinely in the past, but now I'm having simple problems. The screenshot gives an example of joining two Excel tables by ID. The Pivot table at upper right shoul...
If nothing to aggregate PivotTable performs full join. Other words you need to add something to Values
Duh, that was it, thanks.
KenStewart2750 , you are welcome