I have a sql statement that populates an AspxPivotGrid.  Some of the fields in the statement are data fields.  For example paymentamount, claimamount, totalcharge etc.  These fields are data fields that pertain to medical claims.  When I drag these fields to the Drop Data Items Here they display zero.  When I drag them onto Drop Row Fields Here they display data.