Creating pivot table dynamically
 

Hi,
I have a list of fields in a string and woudl liek to create a pivot
table from them, but am not sure how to proceed.
The fields are in a string with a , delimitor but I have also parsed
them into an array in case I could do it that way:

sPageFields = "field1, field2, field 3, field4"
Arr = SplitMultiDelims(sPageFields, ",") 'arr[0] = field1, arr
[1] = field2, etc...

' -- how to populate?::
oPT.AddFields RowFields:="Data", PageFields:=Array(" & Arr(iLoop)
& ")
or
oPT.AddFields RowFields:="Data", PageFields:=Array(" & sPageFields
& ")

Thanks!

Creating pivot table dynamically
 

I don't think you can do it that way, after all, a pivot table is based off
underlying data.

You need to put the data into a table first then assign the table to a
PivotCache and from the cache create the pivot table

"groupie" wrote in message
...
Hi,
I have a list of fields in a string and woudl liek to create a pivot
table from them, but am not sure how to proceed.
The fields are in a string with a , delimitor but I have also parsed
them into an array in case I could do it that way:

sPageFields = "field1, field2, field 3, field4"
Arr = SplitMultiDelims(sPageFields, ",") 'arr[0] = field1, arr
[1] = field2, etc...

' -- how to populate?::
oPT.AddFields RowFields:="Data", PageFields:=Array(" & Arr(iLoop)
& ")
or
oPT.AddFields RowFields:="Data", PageFields:=Array(" & sPageFields
& ")

Thanks!

Creating pivot table dynamically
 

On May 20, 3:50*pm, "Patrick Molloy"
wrote:
I don't think you can do it that way, after all, a pivot table is based off
underlying data.

You need to put the data into a table first then assign the table to a
PivotCache and from the cache create the pivot table

"groupie" wrote in message

...



Hi,
I have a list of fields in a string and woudl liek to create a pivot
table from them, but am not sure how to proceed.
The fields are in a string with a , delimitor but I have also parsed
them into an array in case I could do it that way:

sPageFields = "field1, field2, field 3, field4"
* *Arr = SplitMultiDelims(sPageFields, ",") * *'arr[0] = field1, arr
[1] = field2, etc...

' -- how to populate?::
* *oPT.AddFields RowFields:="Data", PageFields:=Array(" & Arr(iLoop)
& ")
or
* *oPT.AddFields RowFields:="Data", PageFields:=Array(" & sPageFields
& ")

Thanks!- Hide quoted text -

- Show quoted text -

Hi,
Thanks for the reply.
Would you have an example of that? Don't see anything on Google.

Thanks,