| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to ungroup fields in 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.worksheet.functions
|
|||
|
|||
|
How to ungroup fields in pivot table(excel 2007)
Check your other post.
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 | |||
| Ungrouping the fields inside pivot table(Excel 2007) | Excel Discussion (Misc queries) | |||
| No grouping in pivot table (?ungroup?) | 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) | |||
| Can't ungroup in Pivot Table Results - or how do I get what i want | Excel Worksheet Functions | |||
Linear Mode
