Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using merge cells in worksheet for Pivot Table
I am trying to use merge cells to establish a hierarchy in a worksheet that I
will turn into a Pivot Table. By hierarchy, I mean something like a Dog has fleas, bones, chew toys so if I bring up Dog on the pivot table I should get fleas, bones, chew toys to appear. In one column I put Dog then in the column beside it and below it, I put the list of sub-atributes. I merge the cells in the column under Dog till they reach the end of the list of subatributes in the column beside it. It appears like the diagram below. Dog ? M ? M ? M ? When I put the data in the pivot table, the pivot table reads the cells merged with the Dog cell as blank so the sub-attributes are paired with blanks except for the one right next to Dog. Is there someway to establish a hierarchy so that it appears in a Pivot Table? Can this be done with merge cells? -- Gracias |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using merge cells in worksheet for Pivot Table
You'll have to enter the values in every row if you want them to show up
in the pivot table. To hide the duplicates in the source data, you could use conditional formatting, as described he http://www.contextures.com/xlCondFor...html#Duplicate Digno wrote: I am trying to use merge cells to establish a hierarchy in a worksheet that I will turn into a Pivot Table. By hierarchy, I mean something like a Dog has fleas, bones, chew toys so if I bring up Dog on the pivot table I should get fleas, bones, chew toys to appear. In one column I put Dog then in the column beside it and below it, I put the list of sub-atributes. I merge the cells in the column under Dog till they reach the end of the list of subatributes in the column beside it. It appears like the diagram below. Dog ? M ? M ? M ? When I put the data in the pivot table, the pivot table reads the cells merged with the Dog cell as blank so the sub-attributes are paired with blanks except for the one right next to Dog. Is there someway to establish a hierarchy so that it appears in a Pivot Table? Can this be done with merge cells? -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
merge cells in pviot table | Excel Discussion (Misc queries) | |||
Merge cells from all worksheets into a master worksheet | Excel Discussion (Misc queries) | |||
Copying values from pivot table to cells outside pivot table | Excel Discussion (Misc queries) | |||
Pivot Table, merge columns into one row heading? | Excel Discussion (Misc queries) | |||
Pivot Table - 'Merge Labels' option and formatting | Excel Worksheet Functions |