To pivot the data in the grid means to move all column hierarchies to the rows area, all row hierarchies to the columns area, and then recalculate the Result to update the content of the grid.
Original data
Pivoted data
In order to do this, you can use the PivotGrid command. Attach it as shown in the snippet below to a button and associate it to the click event.
In XAML:
<Button Content="Pivot Data">
<igPivot:Commanding.Command>
<igPivot:XamPivotGridCommandSource
EventName="Click"
CommandType="PivotGrid"
TargetName="pivotGrid"/>
</igPivot:Commanding.Command>
</Button>
Related Topics