|
|
|
|
|
| Drop Column Fields Here |
| Grand Total |
| Order Amount | Percent of OrderTotal | Bonus Amount |
 Andrew Fuller | Qtr 1 | $45,700.46 | 3.61 % | 10.00 % |
| Qtr 2 | $67,194.76 | 5.31 % | 15.00 % |
| Qtr 3 | $17,894.70 | 1.41 % | 10.00 % |
| Qtr 4 | $35,747.83 | 2.82 % | 10.00 % |
| Andrew Fuller Total | $166,537.75 | 13.16 % | |
| Anne Dodsworth | Qtr 1 | $27,599.46 | 2.18 % | 10.00 % |
| Qtr 2 | $18,756.28 | 1.48 % | 10.00 % |
| Qtr 3 | $9,316.60 | 0.74 % | 10.00 % |
| Qtr 4 | $21,635.73 | 1.71 % | 10.00 % |
| Anne Dodsworth Total | $77,308.07 | 6.11 % | |
| Grand Total | $1,265,793.04 | 100.00 % | |
|
  
 | Loading… |
|
|
|
|
|
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.
|
 | Loading… |
|
|
|
|