Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ungrouping the fields inside pivot table(Excel 2007)
Hi All,
I have a pivot table having 3 columns. 1:Date 2:Employee 3:Company I am writing function, but problem is that it is grouping the fields like 3/1/2008 x company y company z company 4/1/2008 x company y company I want this type of structure not like privious one: 3/1/2008 x company 3/1/2008 y company 3/1/2008 z company 4/1/2008 x company 4/1/2008 y company |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ungrouping the fields inside pivot table(Excel 2007)
Pivottables won't let you do this.
You could copy the data and paste as values (a new location or over the original???) and then use the techniques at Debra Dalgleish's site to fill those empty cells with the value from above. http://contextures.com/xlDataEntry02.html arun wrote: Hi All, I have a pivot table having 3 columns. 1:Date 2:Employee 3:Company I am writing function, but problem is that it is grouping the fields like 3/1/2008 x company y company z company 4/1/2008 x company y company I want this type of structure not like privious one: 3/1/2008 x company 3/1/2008 y company 3/1/2008 z company 4/1/2008 x company 4/1/2008 y company -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Excel 2007 but allow ungrouping | Excel Discussion (Misc queries) | |||
fields names do not show in excel 2007 pivot table fields list | New Users to Excel | |||
anchor fields to pivot table (Excel 2007) | Excel Discussion (Misc queries) | |||
Excel Pivot Table, Property Fields | Excel Discussion (Misc queries) | |||
How do I link a cell outside a pivot table to one inside the table | Excel Discussion (Misc queries) |