I would like to thank the great help given!
For documentation purposes, Below is the code, suitable for vb.net language, the solution worked perfectly
Private
Sub
radButton1_Click(sender
As
System.
Object
, e
As
System.EventArgs)
Handles
radButton1.Click
For
Each
item
As
IGroupDescription
In
pivotGrid.RowGroupDescriptions
Dim
desc
As
IGroupDescription = item.Clone()
'as IGroupDescription
PivotGrid1.RowGroupDescriptions.Add(desc)
Next
For
Each
item
As
IGroupDescription
In
pivotGrid.ColumnGroupDescriptions
Dim
desc
As
IGroupDescription = item.Clone()
PivotGrid1.ColumnGroupDescriptions.Add(desc)
Next
For
Each
item
As
IAggregateDescription
In
pivotGrid.AggregateDescriptions
Dim
desc
As
IAggregateDescription = item.Clone()
PivotGrid1.AggregateDescriptions.Add(desc)
Next
Dim
newDataSet
As
New
DataTable()
newDataSet = (pivotGrid.DataSource).Copy()
PivotGrid1.DataSource = newDataSet
PivotGrid1.DataMember = pivotGrid.DataMember
End
Sub
Congratulations Telerik Team!