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/