Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combining 2 Pivotfields to 1(Help!!!)
Hi,
In my database I have Field lists containing "Month" and "Year" with the corresponding data below: - Year Month Data 2003 1 0.50 2003 6 0.60 2004 2 0.40 2004 3 0.50 Transforming it to a pivot table: PivotField(1) = "Year" Fieldlist = 2003, 2004 PivotField (2) = Month Fieldlist = 1, 6, 2, 3 Datefield = Data PROBLEM: Instead of creating two pivotfields, I want to merge PivotField(1) and PivotField(2) into a single PivotField therefore containing the ff: Field list: Jan 2003 Jun 2003 Feb 2004 Mar 2004 I dont wanna do it on the database since I want it to be readonly. Thanks and more power!!! --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PivotTable - PivotFields VBA | Excel Discussion (Misc queries) | |||
Deleting PivotFields from a PivotChart in VB.NET | Charts and Charting in Excel | |||
Where does Excel store the orientation of PivotFields? | Charts and Charting in Excel | |||
weird problem with PivotFields CurrentPage | Excel Programming | |||
Pivotfields.CurrentPage | Excel Programming |