Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 23rd 08, 07:18 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 19
Default Pivot Table - Parent to Child Data

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

  #2   Report Post  
Old September 24th 08, 05:23 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,979
Default Pivot Table - Parent to Child Data

The row headings show once in a Pivot Table, and there's no setting you
can change, to force them to repeat.

To create a table with a heading on each row, you could copy the pivot
table, paste it as values in another location, and fill in the blanks,
using the technique shown he

http://www.contextures.com/xlDataEntry02.html

Brennan wrote:
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



--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA code to refresh Child Pivot Table HKS Excel Discussion (Misc queries) 0 May 7th 08 07:49 PM
Finding loops in parent/child relationships GrahamC Excel Discussion (Misc queries) 3 November 22nd 07 06:15 PM
finding multiple parent-child relationships? Keith R Excel Worksheet Functions 4 April 16th 07 04:13 PM
Windows browser Parent/Child structure ERK New Users to Excel 2 December 3rd 06 01:44 AM
Sorting Parent Child kcmtnbiker Excel Worksheet Functions 2 March 31st 06 01:54 AM


All times are GMT +1. The time now is 01:05 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017