pivot table more than 1 column?
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
|