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 |
pivot table more than 1 column?
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 |
All times are GMT +1. The time now is 05:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com