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.