Why PivotGrid shows "1" when no data?

[Tim]

I'm counting number of appearing of a datafield by:

<telerik:PivotGridAggregateField DataField="StatusText" Aggregate="Count" Caption="Counts" UniqueName="Counts" IsHidden="false">
</telerik:PivotGridAggregateField>

The problem appears when I run the pivotgrid, there's a field of (blank) keeps on coming up with a value of "1" unexpectedly. I can see one common point for all (blank) data, they seem to happen to any columns that has no data in it. For Instance, in January 1st. I have no data for that day and the grid gives a value "1" with statustext = (blank) as a substitution. 

What property can I set to stop this? Below is my RadPivotGrid Settings. Thanks.

<telerik:RadPivotGrid ID="RadPivotGrid_DataView" runat="server" ConfigurationPanelSettings-DefaultDeferedLayoutUpdate="false" Height="100%" AggregatesPosition="Rows" AllowSorting="True" OnItemCommand="RadPivotGrid_DataView_ItemCommand" OnCellCreated="RadPivotGrid_DataView_CellCreated" DataSourceID="Sql_Contract_Details" EnableToolTips="True" EnableZoneContextMenu="True" EnableConfigurationPanel="True" OnFieldCreated="RadPivotGrid_DataView_FieldCreated" Skin="Metro" OnCellDataBound="RadPivotGrid_DataView_CellDataBound" Culture="en-GB" OnItemNeedCalculation="RadPivotGrid_DataView_ItemNeedCalculation" AllowPaging="True" PageSize="30">
                       <PagerStyle ChangePageSizeButtonToolTip="Change Page Size" PageSizeControlType="RadComboBox" AlwaysVisible="True" />
                       <Fields>...</Fields>
                       <ClientSettings EnableFieldsDragDrop="True">
                           <Scrolling AllowVerticalScroll="True"></Scrolling>
                       </ClientSettings>
                       <ConfigurationPanelSettings EnableOlapTreeViewLoadOnDemand="True" DefaultDeferedLayoutUpdate="True" LayoutType="OneByFour"></ConfigurationPanelSettings>
                   </telerik:RadPivotGrid>

[Pavlina]

Hi Tim,

The described behavior is really strange and in order to advice you how to prevent it we need to replicate it first. Therefore, I would like to ask you to open a support ticket and send me the data source of RadPivotGrid,  as I guess the problem is related to the data rather than the pivotgrid.

Regards,
Pavlina
Telerik