I'm trying to create a pivot table. I haven't had any trouble with pivot tables that have rows, columns, and data elements.
But if I try to make one that has no row elements:
pt.AddFields ColumnFields:=sColName
I get an error and it fails.
Googling has revealed nothing about using Addfields when there are no row fields.
But if I try to make one that has no row elements:
pt.AddFields ColumnFields:=sColName
I get an error and it fails.
Googling has revealed nothing about using Addfields when there are no row fields.