T
Tony G
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.
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.