Data Shaping Features - Unbound Fields

This demo illustrates the powerful Unbound Fields functionality. The ASPxPivotGrid control lets you create Unbound Fields which are not bound to any field in the control's underlying data source. These fields should be populated manually (for instance, they can display custom information and even use the summary results calculated by the grid). The unbound 'Order Amount' and 'Sales Person' fields are populated via the CustomUnboundFieldData event (this is an equivalent of the calculated columns provided by various data sources). You can specify how values for these fields are calculated using the Sales Person Format and Order Amount Rule combo boxes. The data cells that correspond to unbound 'Percent of OrderTotal' and 'Bonus Amount' unbound fields are populated via the CustomCellDisplayText event. Cell values of the 'Bonus Amount' field are calculated depending upon the value of the 'Order Amount' field. Cell values of the ' Percent of OrderTotal' field specify the percentage ratio of the current order's sum as compared to the total order's sum.