ASP.NET Pivot Table Control

Hierarchical Filter for Grouped Fields

DXperience v2011 vol 2 introduces a new Group Filter feature, which provides an enhanced filtering mechanism for field groups. Each group of fields has a single filter drop-down invoked when clicking the filter button in the header of the first field within the group. The drop-down presents values for all group fields in a tree-like manner, allowing end-users to distinguish between equal field values that correspond to different values of a parent field.

In addition, ASPxPivotGrid introduces a new option allowing you to switch to the filter drop-down behavior available in previous versions of the control.

Display Only Available Filter Items

With this release, filter drop-downs have the ability to ignore field values that cannot be displayed because of filters applied to other fields.

Alternatively, ASPxPivotGrid can disable unavailable filter items instead of hiding them. Disabled filter items are inactive and painted in gray.

New Ways of Presenting Summary Values

We have introduced new summary value display modes that allow your end-users to discover correlations between cell values far more effectively. The pivot grid can now replace raw summaries with the following values:

• Percent of the summary in the Grand Total, Column Grand Total or Row Grand Total value.
• The summary value's rank in its column or row - from largest to smallest values, or vice versa.
• The index value that reflects the summary value's importance in its row and column context. This value is calculated as follows:
  ((value in cell) x (Grand Total of Grand Totals)) / ((Grand Row Total) x (Grand Column Total))

Hide Filter Items

You can now hide or disable filter drop-down items when handling the CustomFilterPopupItems event to prevent end-users from changing their checked state.