Telerik UI for ASP.NET AJAX 2015.2.623
Visual Studion 2013
I am new to the PivotGrid and can't seem to figure out this simple thing. My SQLDataSource returns a list of valves. 2 of the columns are "Valve Size" and "Valve Type". I have a sinple PivotGrid with a row field of "Valve Size" and a column field of "Valve Type":
<telerik:RadPivotGrid ID="RadPivotGrid1" runat="server" DataSourceID="sds_ValvesBuiltByDay">
<telerik:PivotGridColumnField DataField="Valve Type"></telerik:PivotGridColumnField>
<telerik:PivotGridRowField DataField="Valve Size"></telerik:PivotGridRowField>
When the page loads, there are rows for each size returned and columns for tech type but the individual cells in the grid are empty.
(See attached screenshot. The RadGrid below the PivotGrid displays the same data from the same SQL data source)
I want each cell to show the count of records for that size and type combination.
This is probably very simple but I have not found a way to do it.
Please tell me what I am doing wrong.