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.
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. Read More
