dear all, may i know if pivot table column can have 2 which is weight
and prc? i tried many times but still cannot. the column is 1 on top
of another and not side by side. another thing is the vba pivotfields
can have more than 1? currently only can have price. any way to add 1
more which is weight?
pls advise.
thks


desc weight prc
abc 50 43
drf 45 90
qwe 12 50
abc 45 76
abc 33 67


ActiveSheet.PivotTables("PivotTable1").AddFields _
RowFields:="Desc"

ActiveSheet.PivotTables("PivotTable1").PivotFields ("Price").Orientation
= xlDataField

Once the pivot table is built, go to the pivot table and select the data
button. Drag it slightly to the right (until you get some visible feeback)
and release. This should give you two columns.

--
Regards,
Tom Ogilvy


"tango" wrote in message
m...
dear all, may i know if pivot table column can have 2 which is weight
and prc? i tried many times but still cannot. the column is 1 on top
of another and not side by side. another thing is the vba pivotfields
can have more than 1? currently only can have price. any way to add 1
more which is weight?
pls advise.
thks


desc weight prc
abc 50 43
drf 45 90
qwe 12 50
abc 45 76
abc 33 67


ActiveSheet.PivotTables("PivotTable1").AddFields _
RowFields:="Desc"

ActiveSheet.PivotTables("PivotTable1").PivotFields ("Price").Orientation
= xlDataField