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 should have four rows with corresponding One-n and Two-n values. I'm scratching my head, help badly needed.
If nothing to aggregate PivotTable performs full join. Other words you need to add something to Values
3 Replies
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
