In my project i want to display both String and Numeric values in Pivot Grid PivotGridAggregateField .
Check the attached Image for more details.
When i bind String field to PivotGridAggregateField it shows me error.
How to display String Field in PivotGridAggregateField .
<telerik:PivotGridColumnField DataField="Start_Date" Caption="Start_Date" >
</telerik:PivotGridColumnField>
<telerik:PivotGridRowField DataField="MACHINENAME" Caption="MACHINENAME" CellStyle-Width="110px" >
</telerik:PivotGridRowField>
<telerik:PivotGridAggregateField DataField="USER_NM" Caption="USER_NM" >
<HeaderCellTemplate>User Name</HeaderCellTemplate>
</telerik:PivotGridAggregateField>
<telerik:PivotGridAggregateField DataField="PROJECT_ID" Caption="PROJECT_ID" >
<HeaderCellTemplate>PROJECT_ID</HeaderCellTemplate>
</telerik:PivotGridAggregateField>
<telerik:PivotGridAggregateField DataField="OPER" Caption="OPER" >
<HeaderCellTemplate>OPER</HeaderCellTemplate>
</telerik:PivotGridAggregateField>
<telerik:PivotGridAggregateField DataField="Part_NAME" Caption="Part_NAME" >
<HeaderCellTemplate>Part_NAME</HeaderCellTemplate>
</telerik:PivotGridAggregateField>
<telerik:PivotGridAggregateField DataField="SUB_LEG_ID" Caption="SUB_LEG_ID" >
<HeaderCellTemplate>SUB_LEG_ID</HeaderCellTemplate>
</telerik:PivotGridAggregateField>
<telerik:PivotGridAggregateField DataField="ITEM_NM" Caption="ITEM_NM" >
<HeaderCellTemplate>ITEM_NM</HeaderCellTemplate>
</telerik:PivotGridAggregateField>
<telerik:PivotGridAggregateField DataField="OPER_DESCR" Caption="OPER_DESCR" >
<HeaderCellTemplate>OPER_DESCR</HeaderCellTemplate>
</telerik:PivotGridAggregateField>
<telerik:PivotGridAggregateField DataField="WORK_NAME" Caption="WORK_NAME" >
<HeaderCellTemplate>WORK_NAME</HeaderCellTemplate>
</telerik:PivotGridAggregateField>
<telerik:PivotGridAggregateField DataField="RUN_HRS" Caption="RUN_HRS" >
<HeaderCellTemplate>RUN_HRS</HeaderCellTemplate>
</telerik:PivotGridAggregateField>
<telerik:PivotGridAggregateField DataField="MH" Caption="MH" >
<HeaderCellTemplate>MH</HeaderCellTemplate>
</telerik:PivotGridAggregateField>
<telerik:PivotGridAggregateField DataField="MCH" Caption="MCH" >
<HeaderCellTemplate>MCH</HeaderCellTemplate>
</telerik:PivotGridAggregateField>
This works fine but i want to display the Strings in Aggregate field.
How to resolve this.