So can I reverse a key table to one-to-many?

[pete234]

I have a table with employees on it.
It is related to 5 reports in power tables by name (all uniques).
However, I left it at the default detection which leads me to believe this why I am unable to account for those reps without data in some of the reports in my main pivot. In Access, one to many would always give you the nulls and you could decide what to do. I need to do this for the purpose of aligning the names outside of power pivot without more work.

So before I start on another tangent with my current project, is it possible to change in the design window, to a one-to-many? I need all names to show on every pivot regardless of activity in the related reports no matter how it is manipulated. I'm fairly sure it's not possible in regular pivots as I wind up having to create dummy records, which would be a big pain in this instance. Ideas?

 

[powerpivotpro]

Have you tried the pivot option "Show Items with no data?"

PivotTable Options dialog, on the Display tab.

 

[pete234]

Have you tried the pivot option "Show Items with no data?"

PivotTable Options dialog, on the Display tab.

Not but I will first thing in the morning and then...ooops, should have seen that the number of times I've been in that window.