I'm sure you will ask so here is the code.
<
telerik:RadPivotGrid
ID
=
"reportPivotGrid"
runat
=
"server"
OnNeedDataSource
=
"reportPivotGrid_OnNeedDataSource"
AllowSorting
=
"True"
Overlay
=
"True"
EnableToolTips
=
"True"
Skin
=
"Windows7"
ColumnHeaderZoneText
=
""
DataHeaderZoneText
=
""
ShowFilterHeaderZone
=
"False"
FilterWindow-Width
=
"600"
FilterWindow-Height
=
"550"
UseQueryableDataProvider
=
"True"
>
<
ClientSettings
EnableFieldsDragDrop
=
"false"
Scrolling-SaveScrollPosition
=
"True"
/>
<
PagerStyle
ChangePageSizeButtonToolTip
=
"Change Page Size"
PageSizeControlType
=
"RadComboBox"
></
PagerStyle
>
<
RowHeaderCellStyle
Width
=
"200px"
/>
<
Fields
>
<
telerik:PivotGridRowField
DataField
=
"Rep"
ZoneIndex
=
"1"
Caption
=
"Rep"
SortOrder
=
"Ascending"
>
</
telerik:PivotGridRowField
>
<
telerik:PivotGridColumnField
DataField
=
"Year"
SortOrder
=
"Descending"
Caption
=
"Year"
>
</
telerik:PivotGridColumnField
>
<
telerik:PivotGridColumnField
DataField
=
"Month"
Caption
=
"Month"
SortOrder
=
"Descending"
>
</
telerik:PivotGridColumnField
>
<
telerik:PivotGridAggregateField
DataField
=
"Sale"
Aggregate
=
"Sum"
DataFormatString
=
"{0:C}"
Caption
=
"Sales"
>
<
TotalFormat
Level
=
"0"
Axis
=
"Rows"
TotalFunction
=
"NoCalculation"
SortOrder
=
"Ascending"
></
TotalFormat
>
</
telerik:PivotGridAggregateField
>
</
Fields
>
</
telerik:RadPivotGrid
>