Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PivotTable: AddDataField method
Hello World!
I'm using the AddDatfield method to add the data field into a pivottable as part of a custom pivot builder. It takes it's values from a simple interface. Here's the gubbins; (With MyPivottable etc.etc..) ..AddDataField .PivotFields(frmMain.L24.Caption), Plbl, xlCount (Plbl=descriptive string of label) (frmMain.L24.Caption=selected field string) The problem is that when the user elects to have one of the selected row or column fields to also use as the data field, the resulting table has that row/column field removed from where it was and used as data but not split out by it's values along the the row or column (phew! hope that makes sense). I have a feeling that I should be setting the field orientation but can I do it for the same field twice? Any help appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Please post this thread a correct full method, method about | New Users to Excel | |||
Please post this thread a complete correct method, method about te | New Users to Excel | |||
Creating a PivotTable w/o selecting data in an existing PivotTable | Excel Discussion (Misc queries) | |||
Which method to use | New Users to Excel | |||
best method | Excel Discussion (Misc queries) |