Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keep a column of comments "with" pivot table as pivot tables datachanges, causing rows to be added and deleted. | Excel Discussion (Misc queries) | |||
New Column In Pivot Table | Excel Discussion (Misc queries) | |||
Pivot Table - how to add column on the same row | Excel Worksheet Functions | |||
Sorting a Pivot Table Column that is not the first column... | Excel Worksheet Functions | |||
pivot table, how to add 1 column only | Excel Discussion (Misc queries) |