We are adding several important pivot tables improvements in
VIBlend WPF DataGrid. The upcoming release will feature four additional data
aggregation functions: StDev, StDevP, Var and VarP. The StDev function
calculates the standard deviation on a sample of values while the StDevP
function calculates it on the entire population of values. The Var and VarP
functions calculate the variance on a sample of values and on the entire
population. With these new functions you will be able to load the WPF DataGrid
with a set of data records, pivot by any column and see the aggregated results.
All this can be expressed entirely in XAML:
<viblend:DataGrid
AutoGenerateColumns="True"
PivotValuesOnRows="False"
x:Name="pivotGrid1" >
<viblend:DataGrid.BoundPivotRows>
<viblend:BoundField Text="Country" DataField="Country"/>
<viblend:BoundField Text="Region" DataField="Region"/>
<viblend:BoundField Text="City" DataField="City"/>
</viblend:DataGrid.BoundPivotRows>
<viblend:DataGrid.BoundPivotColumns>
<viblend:BoundField Text="Shipping Company" DataField="ShipperCompany"/>
</viblend:DataGrid.BoundPivotColumns>
<viblend:DataGrid.BoundPivotValues>
<viblend:BoundValueField
Text="Count"
DataField="ExtendedPrice"
Function="Count"/>
<viblend:BoundValueField
Text="Sum"
DataField="ExtendedPrice"
Function="Sum"/>
<viblend:BoundValueField Text="Standard Deviation"
DataField="ExtendedPrice"
Function="StDev"
SortMode="Automatic"/>
</viblend:DataGrid.BoundPivotValues>
</viblend:DataGrid>
Another important key feature that you can expect in the new
release is the Pivot Design Panel. The Pivot Design panel provides an intuitive
and easy to use drag and drop interface for defining pivot table views. You can
choose the pivot rows, pivot columns, pivot filters, data fields and data
aggregation functions. This solution is
ideal for building a wide range of in-house OLAP and BI applications. The Pivot
Design panel is already available in our Silverlight and Windows Forms suites.