VIBlend
Home Products Downloads Purchase Support Forum About Blog

New Pivot Table aggregation functions coming to VIBlend WPF DataGrid

by viblend 10. March 2011 02:59

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.

Comments are closed

About the author

Some text that describes me

Tag cloud

Recent comments

Comment RSS
Copyright © 2011 VIBlend  
ALL RIGHTS RESERVED  
 
Terms of Use | Privacy Policy
WinForms Controls Purchase Online About Us
       
DataGrid Navigation Pane Technical Support Blog
ScrollBar TreeView
ListBox ProgressBar Downloads Register
ComboBox Buttons
TabControl Editors Documentation Client Login

VIBlend Blog is powered by BlogEngine.NET