Hello all,

I would like for my pivot table to display the parent data for eah child.
For example, right now the pivot will display data like so:

Parent Child
Child
Child

The data would then be to the right.

I would like for it to display the data like so:

Parent Child
Parent Child
Parent Child
Parent2 Child2
Parent2 Child2

Please let me know how I can do this. Thanks

Brennan