Controls / RadPivotGrid / Getting Started

New to Telerik UI for WPF? Download free 30-day trial

Getting Started

This article will explain a basic implementation of RadPivotGrid using LocalDataSourceProvider.

Adding RadPivotGrid to your application.

RadPivotGrid can be used after adding reference to the following assemblies:

  • Telerik.Pivot.Core
  • Telerik.Windows.Controls.Pivot
  • Telerik.Windows.Controls

There are two ways to add RadPivotGrid to your application:

  • Drag RadPivotGrid from the Toolbox. It can be found under UI for WPF but only if you have installed Telerik controls.

Rad Pivot Grid Getting Started 1

  • Create it in the XAML directly:

<pivot:RadPivotGrid Name="radPivotGrid1">             
</pivot:RadPivotGrid>

You will have to define the pivot namespace in your XAML: xmlns:pivot="http://schemas.telerik.com/2008/xaml/presentation/pivot"

Create Data to Show in RadPivotGrid

In our application we will show data for some office materials - their quantity, price through the year, etc. So our first task is to create a class that will present one product. 

public class Product 
{ 
    public string Name { get; set; } 
    public int Quantity { get; set; } 
    public double Price { get; set; } 
    public DateTime Date { get; set; } 
} 

Public Class Product 
    Public Property Name() As String 
        Get 
            Return m_Name 
        End Get 
        Set(value As String) 
            m_Name = value 
        End Set 
    End Property 
    Private m_Name As String 
    Public Property Quantity() As Integer 
        Get 
            Return m_Quantity 
        End Get 
        Set(value As Integer) 
            m_Quantity = value 
        End Set 
    End Property 
    Private m_Quantity As Integer 
    Public Property Price() As Double 
        Get 
            Return m_Price 
        End Get 
        Set(value As Double) 
            m_Price = value 
        End Set 
    End Property 
    Private m_Price As Double 
    Public Property Date As DateTime 
        Get 
            Return m_Date 
        End Get 
        Set(value As DateTime) 
            m_Date = value 
        End Set 
    End Property 
    Private m_Date As DateTime 
End Class

Now we'll add a method that will create a sample data for our application:

private static IList<Product> GeneratePivotData() 
{ 
    IList<Product> PivotData = new List<Product>() 
    { 
        new Product() { Name = "Pen", Date = new DateTime(2012,1,1,0,0,0), Price = 10.40, Quantity = 148 }, 
        new Product() { Name = "Pen", Date = new DateTime(2012,2,1,0,0,0), Price = 10.99, Quantity = 122 }, 
        new Product() { Name = "Pen", Date = new DateTime(2012,3,1,0,0,0), Price = 11.24, Quantity = 80 }, 
        new Product() { Name = "Pen", Date = new DateTime(2012,4,1,0,0,0), Price = 11.24, Quantity = 90 }, 
        new Product() { Name = "Pen", Date = new DateTime(2012,5,1,0,0,0), Price = 11.14, Quantity = 140 }, 
        new Product() { Name = "Pen", Date = new DateTime(2012,6,1,0,0,0), Price = 10.89, Quantity = 162 }, 
        new Product() { Name = "Pen", Date = new DateTime(2012,7,1,0,0,0), Price = 10.89, Quantity = 181 }, 
        new Product() { Name = "Pen", Date = new DateTime(2012,8,1,0,0,0), Price = 10.88, Quantity = 180 }, 
        new Product() { Name = "Pen", Date = new DateTime(2012,9,1,0,0,0), Price = 11.00, Quantity = 116 }, 
        new Product() { Name = "Pen", Date = new DateTime(2012,10,1,0,0,0), Price = 10.99, Quantity = 128 }, 
        new Product() { Name = "Pen", Date = new DateTime(2012,11,1,0,0,0), Price = 10.95, Quantity = 145 }, 
        new Product() { Name = "Pen", Date = new DateTime(2012,12,1,0,0,0), Price = 10.45, Quantity = 189 }, 
        new Product() { Name = "Pencil", Date = new DateTime(2012,1,1,0,0,0), Price = 5.22, Quantity = 100 }, 
        new Product() { Name = "Pencil", Date = new DateTime(2012,2,1,0,0,0), Price = 5.99, Quantity = 85 }, 
        new Product() { Name = "Pencil", Date = new DateTime(2012,3,1,0,0,0), Price = 6.04, Quantity = 80 }, 
        new Product() { Name = "Pencil", Date = new DateTime(2012,4,1,0,0,0), Price = 6.28, Quantity = 72 }, 
        new Product() { Name = "Pencil", Date = new DateTime(2012,5,1,0,0,0), Price = 6.12, Quantity = 99 }, 
        new Product() { Name = "Pencil", Date = new DateTime(2012,6,1,0,0,0), Price = 6.59, Quantity = 40 }, 
        new Product() { Name = "Pencil", Date = new DateTime(2012,7,1,0,0,0), Price = 6.29, Quantity = 68 }, 
        new Product() { Name = "Pencil", Date = new DateTime(2012,8,1,0,0,0), Price = 5.99, Quantity = 95 }, 
        new Product() { Name = "Pencil", Date = new DateTime(2012,9,1,0,0,0), Price = 5.89, Quantity = 120 }, 
        new Product() { Name = "Pencil", Date = new DateTime(2012,10,1,0,0,0), Price = 5.99, Quantity = 105 }, 
        new Product() { Name = "Pencil", Date = new DateTime(2012,11,1,0,0,0), Price = 5.96, Quantity = 111 }, 
        new Product() { Name = "Pencil", Date = new DateTime(2012,12,1,0,0,0), Price = 5.99, Quantity = 108 }, 
        new Product() { Name = "Notebook", Date = new DateTime(2012,1,1,0,0,0), Price = 22.86, Quantity = 88 }, 
        new Product() { Name = "Notebook", Date = new DateTime(2012,2,1,0,0,0), Price = 23.02, Quantity = 95}, 
        new Product() { Name = "Notebook", Date = new DateTime(2012,3,1,0,0,0), Price = 23.22, Quantity = 102 }, 
        new Product() { Name = "Notebook", Date = new DateTime(2012,4,1,0,0,0), Price = 21.99, Quantity = 95}, 
        new Product() { Name = "Notebook", Date = new DateTime(2012,5,1,0,0,0), Price = 22.45, Quantity = 84}, 
        new Product() { Name = "Notebook", Date = new DateTime(2012,6,1,0,0,0), Price = 22.56, Quantity = 96 }, 
        new Product() { Name = "Notebook", Date = new DateTime(2012,7,1,0,0,0), Price = 22.88, Quantity = 88}, 
        new Product() { Name = "Notebook", Date = new DateTime(2012,8,1,0,0,0), Price = 22.42, Quantity = 99}, 
        new Product() { Name = "Notebook", Date = new DateTime(2012,9,1,0,0,0), Price = 22.56, Quantity = 111}, 
        new Product() { Name = "Notebook", Date = new DateTime(2012,10,1,0,0,0), Price = 22.18, Quantity = 102 }, 
        new Product() { Name = "Notebook", Date = new DateTime(2012,11,1,0,0,0), Price = 22.93, Quantity = 105 }, 
        new Product() { Name = "Notebook", Date = new DateTime(2012,12,1,0,0,0), Price = 22.89, Quantity = 122 }, 
    }; 
 
    return PivotData; 
} 

Private Shared Function GeneratePivotData() As IList(Of Product) 
    Dim PivotData As IList(Of Product) = New List(Of Product)() From { _ 
New Product() With { _ 
 .Name = "Pen", _ 
 .[Date] = New DateTime(2012, 1, 1, 0, 0, 0), _ 
 .Price = 10.4, _ 
 .Quantity = 148 _ 
}, _ 
New Product() With { _ 
 .Name = "Pen", _ 
 .[Date] = New DateTime(2012, 2, 1, 0, 0, 0), _ 
 .Price = 10.99, _ 
 .Quantity = 122 _ 
}, _ 
New Product() With { _ 
 .Name = "Pen", _ 
 .[Date] = New DateTime(2012, 3, 1, 0, 0, 0), _ 
 .Price = 11.24, _ 
 .Quantity = 80 _ 
}, _ 
New Product() With { _ 
 .Name = "Pen", _ 
 .[Date] = New DateTime(2012, 4, 1, 0, 0, 0), _ 
 .Price = 11.24, _ 
 .Quantity = 90 _ 
}, _ 
New Product() With { _ 
 .Name = "Pen", _ 
 .[Date] = New DateTime(2012, 5, 1, 0, 0, 0), _ 
 .Price = 11.14, _ 
 .Quantity = 140 _ 
}, _ 
New Product() With { _ 
 .Name = "Pen", _ 
 .[Date] = New DateTime(2012, 6, 1, 0, 0, 0), _ 
 .Price = 10.89, _ 
 .Quantity = 162 _ 
}, _ 
New Product() With { _ 
 .Name = "Pen", _ 
 .[Date] = New DateTime(2012, 7, 1, 0, 0, 0), _ 
 .Price = 10.89, _ 
 .Quantity = 181 _ 
}, _ 
New Product() With { _ 
 .Name = "Pen", _ 
 .[Date] = New DateTime(2012, 8, 1, 0, 0, 0), _ 
 .Price = 10.88, _ 
 .Quantity = 180 _ 
}, _ 
New Product() With { _ 
 .Name = "Pen", _ 
 .[Date] = New DateTime(2012, 9, 1, 0, 0, 0), _ 
 .Price = 11.0, _ 
 .Quantity = 116 _ 
}, _ 
New Product() With { _ 
 .Name = "Pen", _ 
 .[Date] = New DateTime(2012, 10, 1, 0, 0, 0), _ 
 .Price = 10.99, _ 
 .Quantity = 128 _ 
}, _ 
New Product() With { _ 
 .Name = "Pen", _ 
 .[Date] = New DateTime(2012, 11, 1, 0, 0, 0), _ 
 .Price = 10.95, _ 
 .Quantity = 145 _ 
}, _ 
New Product() With { _ 
 .Name = "Pen", _ 
 .[Date] = New DateTime(2012, 12, 1, 0, 0, 0), _ 
 .Price = 10.45, _ 
 .Quantity = 189 _ 
}, _ 
New Product() With { _ 
 .Name = "Pencil", _ 
 .[Date] = New DateTime(2012, 1, 1, 0, 0, 0), _ 
 .Price = 5.22, _ 
 .Quantity = 100 _ 
}, _ 
New Product() With { _ 
 .Name = "Pencil", _ 
 .[Date] = New DateTime(2012, 2, 1, 0, 0, 0), _ 
 .Price = 5.99, _ 
 .Quantity = 85 _ 
}, _ 
New Product() With { _ 
 .Name = "Pencil", _ 
 .[Date] = New DateTime(2012, 3, 1, 0, 0, 0), _ 
 .Price = 6.04, _ 
 .Quantity = 80 _ 
}, _ 
New Product() With { _ 
 .Name = "Pencil", _ 
 .[Date] = New DateTime(2012, 4, 1, 0, 0, 0), _ 
 .Price = 6.28, _ 
 .Quantity = 72 _ 
}, _ 
New Product() With { _ 
 .Name = "Pencil", _ 
 .[Date] = New DateTime(2012, 5, 1, 0, 0, 0), _ 
 .Price = 6.12, _ 
 .Quantity = 99 _ 
}, _ 
New Product() With { _ 
 .Name = "Pencil", _ 
 .[Date] = New DateTime(2012, 6, 1, 0, 0, 0), _ 
 .Price = 6.59, _ 
 .Quantity = 40 _ 
}, _ 
New Product() With { _ 
 .Name = "Pencil", _ 
 .[Date] = New DateTime(2012, 7, 1, 0, 0, 0), _ 
 .Price = 6.29, _ 
 .Quantity = 68 _ 
}, _ 
New Product() With { _ 
 .Name = "Pencil", _ 
 .[Date] = New DateTime(2012, 8, 1, 0, 0, 0), _ 
 .Price = 5.99, _ 
 .Quantity = 95 _ 
}, _ 
New Product() With { _ 
 .Name = "Pencil", _ 
 .[Date] = New DateTime(2012, 9, 1, 0, 0, 0), _ 
 .Price = 5.89, _ 
 .Quantity = 120 _ 
}, _ 
New Product() With { _ 
 .Name = "Pencil", _ 
 .[Date] = New DateTime(2012, 10, 1, 0, 0, 0), _ 
 .Price = 5.99, _ 
 .Quantity = 105 _ 
}, _ 
New Product() With { _ 
 .Name = "Pencil", _ 
 .[Date] = New DateTime(2012, 11, 1, 0, 0, 0), _ 
 .Price = 5.96, _ 
 .Quantity = 111 _ 
}, _ 
New Product() With { _ 
 .Name = "Pencil", _ 
 .[Date] = New DateTime(2012, 12, 1, 0, 0, 0), _ 
 .Price = 5.99, _ 
 .Quantity = 108 _ 
}, _ 
New Product() With { _ 
 .Name = "Notebook", _ 
 .[Date] = New DateTime(2012, 1, 1, 0, 0, 0), _ 
 .Price = 22.86, _ 
 .Quantity = 88 _ 
}, _ 
New Product() With { _ 
 .Name = "Notebook", _ 
 .[Date] = New DateTime(2012, 2, 1, 0, 0, 0), _ 
 .Price = 23.02, _ 
 .Quantity = 95 _ 
}, _ 
New Product() With { _ 
 .Name = "Notebook", _ 
 .[Date] = New DateTime(2012, 3, 1, 0, 0, 0), _ 
 .Price = 23.22, _ 
 .Quantity = 102 _ 
}, _ 
New Product() With { _ 
 .Name = "Notebook", _ 
 .[Date] = New DateTime(2012, 4, 1, 0, 0, 0), _ 
 .Price = 21.99, _ 
 .Quantity = 95 _ 
}, _ 
New Product() With { _ 
 .Name = "Notebook", _ 
 .[Date] = New DateTime(2012, 5, 1, 0, 0, 0), _ 
 .Price = 22.45, _ 
 .Quantity = 84 _ 
}, _ 
New Product() With { _ 
 .Name = "Notebook", _ 
 .[Date] = New DateTime(2012, 6, 1, 0, 0, 0), _ 
 .Price = 22.56, _ 
 .Quantity = 96 _ 
}, _ 
New Product() With { _ 
 .Name = "Notebook", _ 
 .[Date] = New DateTime(2012, 7, 1, 0, 0, 0), _ 
 .Price = 22.88, _ 
 .Quantity = 88 _ 
}, _ 
New Product() With { _ 
 .Name = "Notebook", _ 
 .[Date] = New DateTime(2012, 8, 1, 0, 0, 0), _ 
 .Price = 22.42, _ 
 .Quantity = 99 _ 
}, _ 
New Product() With { _ 
 .Name = "Notebook", _ 
 .[Date] = New DateTime(2012, 9, 1, 0, 0, 0), _ 
 .Price = 22.56, _ 
 .Quantity = 111 _ 
}, _ 
New Product() With { _ 
 .Name = "Notebook", _ 
 .[Date] = New DateTime(2012, 10, 1, 0, 0, 0), _ 
 .Price = 22.18, _ 
 .Quantity = 102 _ 
}, _ 
New Product() With { _ 
 .Name = "Notebook", _ 
 .[Date] = New DateTime(2012, 11, 1, 0, 0, 0), _ 
 .Price = 22.93, _ 
 .Quantity = 105 _ 
}, _ 
New Product() With { _ 
 .Name = "Notebook", _ 
 .[Date] = New DateTime(2012, 12, 1, 0, 0, 0), _ 
 .Price = 22.89, _ 
 .Quantity = 122 _ 
} _ 
} 
 
    Return PivotData 
End Function

Create the RadPivotGrid LocalDataSourceProvider

It is time to define the DataSource for our RadPivotGrid. We'll do it in the resources in our XAML. The idea of the DataSourceProvider is to define which properties will be shown as a Columns, Rows and Aggregates. For our example we'll use Name as a Row, Date as a Column, Price and Quantity as Aggregates. 

<pivot:LocalDataSourceProvider x:Key="LocalDataProvider" AggregatesPosition="Rows"> 
    <pivot:LocalDataSourceProvider.RowGroupDescriptions> 
        <pivot:PropertyGroupDescription PropertyName="Name" /> 
    </pivot:LocalDataSourceProvider.RowGroupDescriptions> 
    <pivot:LocalDataSourceProvider.ColumnGroupDescriptions> 
        <pivot:DateTimeGroupDescription PropertyName="Date" Step="Month" /> 
    </pivot:LocalDataSourceProvider.ColumnGroupDescriptions> 
    <pivot:LocalDataSourceProvider.AggregateDescriptions> 
        <pivot:PropertyAggregateDescription PropertyName="Price" StringFormat="C" AggregateFunction="Average" /> 
        <pivot:PropertyAggregateDescription PropertyName="Quantity"/> 
    </pivot:LocalDataSourceProvider.AggregateDescriptions> 
</pivot:LocalDataSourceProvider>
In the definition of the RadPivotGrid you'll have to set the DataProvider property to the LocalDataSourceProvider we've just created. 

<pivot:RadPivotGrid Name="radPivotGrid1" DataProvider="{StaticResource LocalDataProvider}" >             
</pivot:RadPivotGrid>
The DataProvider is set, but it still doesn't have any data in it. It's time to use our GenerateData method. Add the following code to your code behind: 

InitializeComponent(); 
(this.Resources["LocalDataProvider"] as LocalDataSourceProvider).ItemsSource = GeneratePivotData(); 

InitializeComponent() 
TryCast(Me.Resources("LocalDataProvider"), LocalDataSourceProvider).ItemsSource = GeneratePivotData()

Final Result and Full Project

Let's start our application. Here's the result:

Rad Pivot Grid Getting Started 2

Here's the full implementation of our project:

<Window x:Class="RadPivotGrid_GettingStarted.MainWindow" 
                xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" 
                xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" 
                xmlns:telerik="http://schemas.telerik.com/2008/xaml/presentation" 
                xmlns:local="clr-namespace:RadPivotGrid_GettingStarted" 
                xmlns:pivot="http://schemas.telerik.com/2008/xaml/presentation/pivot" 
                Title="MainWindow" Height="350" Width="525" > 
    <Window.Resources> 
        <pivot:LocalDataSourceProvider x:Key="LocalDataProvider" AggregatesPosition="Rows"> 
            <pivot:LocalDataSourceProvider.RowGroupDescriptions> 
                <pivot:PropertyGroupDescription PropertyName="Name" /> 
            </pivot:LocalDataSourceProvider.RowGroupDescriptions> 
            <pivot:LocalDataSourceProvider.ColumnGroupDescriptions> 
                <pivot:DateTimeGroupDescription PropertyName="Date" Step="Month" /> 
            </pivot:LocalDataSourceProvider.ColumnGroupDescriptions> 
            <pivot:LocalDataSourceProvider.AggregateDescriptions> 
                <pivot:PropertyAggregateDescription PropertyName="Price" StringFormat="C" AggregateFunction="Average" /> 
                <pivot:PropertyAggregateDescription PropertyName="Quantity"/> 
            </pivot:LocalDataSourceProvider.AggregateDescriptions> 
        </pivot:LocalDataSourceProvider> 
    </Window.Resources> 
        <Grid> 
        <pivot:RadPivotGrid Name="radPivotGrid1" DataProvider="{StaticResource LocalDataProvider}" >             
        </pivot:RadPivotGrid> 
    </Grid> 
</Window> 


using System; 
using System.Collections.Generic; 
using System.Windows; 
using Telerik.Pivot.Core; 
 
namespace RadPivotGrid_GettingStarted 
{ 
    public class Product 
    { 
        public string Name { get; set; } 
        public int Quantity { get; set; } 
        public double Price { get; set; } 
        public DateTime Date { get; set; } 
    } 
 
    public partial class MainWindow : Window 
    { 
        public MainWindow() 
        { 
            InitializeComponent(); 
            (this.Resources["LocalDataProvider"] as LocalDataSourceProvider).ItemsSource = GeneratePivotData(); 
        } 
 
        private static IList<Product> GeneratePivotData() 
        { 
            IList<Product> PivotData = new List<Product>() 
            { 
                new Product() { Name = "Pen", Date = new DateTime(2012,1,1,0,0,0), Price = 10.40, Quantity = 148 }, 
                new Product() { Name = "Pen", Date = new DateTime(2012,2,1,0,0,0), Price = 10.99, Quantity = 122 }, 
                new Product() { Name = "Pen", Date = new DateTime(2012,3,1,0,0,0), Price = 11.24, Quantity = 80 }, 
                new Product() { Name = "Pen", Date = new DateTime(2012,4,1,0,0,0), Price = 11.24, Quantity = 90 }, 
                new Product() { Name = "Pen", Date = new DateTime(2012,5,1,0,0,0), Price = 11.14, Quantity = 140 }, 
                new Product() { Name = "Pen", Date = new DateTime(2012,6,1,0,0,0), Price = 10.89, Quantity = 162 }, 
                new Product() { Name = "Pen", Date = new DateTime(2012,7,1,0,0,0), Price = 10.89, Quantity = 181 }, 
                new Product() { Name = "Pen", Date = new DateTime(2012,8,1,0,0,0), Price = 10.88, Quantity = 180 }, 
                new Product() { Name = "Pen", Date = new DateTime(2012,9,1,0,0,0), Price = 11.00, Quantity = 116 }, 
                new Product() { Name = "Pen", Date = new DateTime(2012,10,1,0,0,0), Price = 10.99, Quantity = 128 }, 
                new Product() { Name = "Pen", Date = new DateTime(2012,11,1,0,0,0), Price = 10.95, Quantity = 145 }, 
                new Product() { Name = "Pen", Date = new DateTime(2012,12,1,0,0,0), Price = 10.45, Quantity = 189 }, 
                new Product() { Name = "Pencil", Date = new DateTime(2012,1,1,0,0,0), Price = 5.22, Quantity = 100 }, 
                new Product() { Name = "Pencil", Date = new DateTime(2012,2,1,0,0,0), Price = 5.99, Quantity = 85 }, 
                new Product() { Name = "Pencil", Date = new DateTime(2012,3,1,0,0,0), Price = 6.04, Quantity = 80 }, 
                new Product() { Name = "Pencil", Date = new DateTime(2012,4,1,0,0,0), Price = 6.28, Quantity = 72 }, 
                new Product() { Name = "Pencil", Date = new DateTime(2012,5,1,0,0,0), Price = 6.12, Quantity = 99 }, 
                new Product() { Name = "Pencil", Date = new DateTime(2012,6,1,0,0,0), Price = 6.59, Quantity = 40 }, 
                new Product() { Name = "Pencil", Date = new DateTime(2012,7,1,0,0,0), Price = 6.29, Quantity = 68 }, 
                new Product() { Name = "Pencil", Date = new DateTime(2012,8,1,0,0,0), Price = 5.99, Quantity = 95 }, 
                new Product() { Name = "Pencil", Date = new DateTime(2012,9,1,0,0,0), Price = 5.89, Quantity = 120 }, 
                new Product() { Name = "Pencil", Date = new DateTime(2012,10,1,0,0,0), Price = 5.99, Quantity = 105 }, 
                new Product() { Name = "Pencil", Date = new DateTime(2012,11,1,0,0,0), Price = 5.96, Quantity = 111 }, 
                new Product() { Name = "Pencil", Date = new DateTime(2012,12,1,0,0,0), Price = 5.99, Quantity = 108 }, 
                new Product() { Name = "Notebook", Date = new DateTime(2012,1,1,0,0,0), Price = 22.86, Quantity = 88 }, 
                new Product() { Name = "Notebook", Date = new DateTime(2012,2,1,0,0,0), Price = 23.02, Quantity = 95}, 
                new Product() { Name = "Notebook", Date = new DateTime(2012,3,1,0,0,0), Price = 23.22, Quantity = 102 }, 
                new Product() { Name = "Notebook", Date = new DateTime(2012,4,1,0,0,0), Price = 21.99, Quantity = 95}, 
                new Product() { Name = "Notebook", Date = new DateTime(2012,5,1,0,0,0), Price = 22.45, Quantity = 84}, 
                new Product() { Name = "Notebook", Date = new DateTime(2012,6,1,0,0,0), Price = 22.56, Quantity = 96 }, 
                new Product() { Name = "Notebook", Date = new DateTime(2012,7,1,0,0,0), Price = 22.88, Quantity = 88}, 
                new Product() { Name = "Notebook", Date = new DateTime(2012,8,1,0,0,0), Price = 22.42, Quantity = 99}, 
                new Product() { Name = "Notebook", Date = new DateTime(2012,9,1,0,0,0), Price = 22.56, Quantity = 111}, 
                new Product() { Name = "Notebook", Date = new DateTime(2012,10,1,0,0,0), Price = 22.18, Quantity = 102 }, 
                new Product() { Name = "Notebook", Date = new DateTime(2012,11,1,0,0,0), Price = 22.93, Quantity = 105 }, 
                new Product() { Name = "Notebook", Date = new DateTime(2012,12,1,0,0,0), Price = 22.89, Quantity = 122 }, 
            }; 
 
            return PivotData; 
        } 
    } 
} 

Imports System 
Imports System.Collections.Generic 
Imports System.Windows 
Imports Telerik.Pivot.Core 
 
Public Class Product 
    Public Property Name() As String 
        Get 
            Return m_Name 
        End Get 
        Set(value As String) 
            m_Name = value 
        End Set 
    End Property 
    Private m_Name As String 
    Public Property Quantity() As Integer 
        Get 
            Return m_Quantity 
        End Get 
        Set(value As Integer) 
            m_Quantity = value 
        End Set 
    End Property 
    Private m_Quantity As Integer 
    Public Property Price() As Double 
        Get 
            Return m_Price 
        End Get 
        Set(value As Double) 
            m_Price = value 
        End Set 
    End Property 
    Private m_Price As Double 
    Public Property Date As DateTime 
        Get 
            Return m_Date 
        End Get 
        Set(value As DateTime) 
            m_Date = value 
        End Set 
    End Property 
    Private m_Date As DateTime 
End Class 
 
Partial Public Class MainWindow 
    Public Sub New() 
        InitializeComponent() 
        TryCast(Me.Resources("LocalDataProvider"), LocalDataSourceProvider).ItemsSource = GeneratePivotData() 
    End Sub 
 
    Private Shared Function GeneratePivotData() As IList(Of Product) 
        Dim PivotData As IList(Of Product) = New List(Of Product)() From { _ 
    New Product() With { _ 
     .Name = "Pen", _ 
     .[Date] = New DateTime(2012, 1, 1, 0, 0, 0), _ 
     .Price = 10.4, _ 
     .Quantity = 148 _ 
    }, _ 
    New Product() With { _ 
     .Name = "Pen", _ 
     .[Date] = New DateTime(2012, 2, 1, 0, 0, 0), _ 
     .Price = 10.99, _ 
     .Quantity = 122 _ 
    }, _ 
    New Product() With { _ 
     .Name = "Pen", _ 
     .[Date] = New DateTime(2012, 3, 1, 0, 0, 0), _ 
     .Price = 11.24, _ 
     .Quantity = 80 _ 
    }, _ 
    New Product() With { _ 
     .Name = "Pen", _ 
     .[Date] = New DateTime(2012, 4, 1, 0, 0, 0), _ 
     .Price = 11.24, _ 
     .Quantity = 90 _ 
    }, _ 
    New Product() With { _ 
     .Name = "Pen", _ 
     .[Date] = New DateTime(2012, 5, 1, 0, 0, 0), _ 
     .Price = 11.14, _ 
     .Quantity = 140 _ 
    }, _ 
    New Product() With { _ 
     .Name = "Pen", _ 
     .[Date] = New DateTime(2012, 6, 1, 0, 0, 0), _ 
     .Price = 10.89, _ 
     .Quantity = 162 _ 
    }, _ 
    New Product() With { _ 
     .Name = "Pen", _ 
     .[Date] = New DateTime(2012, 7, 1, 0, 0, 0), _ 
     .Price = 10.89, _ 
     .Quantity = 181 _ 
    }, _ 
    New Product() With { _ 
     .Name = "Pen", _ 
     .[Date] = New DateTime(2012, 8, 1, 0, 0, 0), _ 
     .Price = 10.88, _ 
     .Quantity = 180 _ 
    }, _ 
    New Product() With { _ 
     .Name = "Pen", _ 
     .[Date] = New DateTime(2012, 9, 1, 0, 0, 0), _ 
     .Price = 11.0, _ 
     .Quantity = 116 _ 
    }, _ 
    New Product() With { _ 
     .Name = "Pen", _ 
     .[Date] = New DateTime(2012, 10, 1, 0, 0, 0), _ 
     .Price = 10.99, _ 
     .Quantity = 128 _ 
    }, _ 
    New Product() With { _ 
     .Name = "Pen", _ 
     .[Date] = New DateTime(2012, 11, 1, 0, 0, 0), _ 
     .Price = 10.95, _ 
     .Quantity = 145 _ 
    }, _ 
    New Product() With { _ 
     .Name = "Pen", _ 
     .[Date] = New DateTime(2012, 12, 1, 0, 0, 0), _ 
     .Price = 10.45, _ 
     .Quantity = 189 _ 
    }, _ 
    New Product() With { _ 
     .Name = "Pencil", _ 
     .[Date] = New DateTime(2012, 1, 1, 0, 0, 0), _ 
     .Price = 5.22, _ 
     .Quantity = 100 _ 
    }, _ 
    New Product() With { _ 
     .Name = "Pencil", _ 
     .[Date] = New DateTime(2012, 2, 1, 0, 0, 0), _ 
     .Price = 5.99, _ 
     .Quantity = 85 _ 
    }, _ 
    New Product() With { _ 
     .Name = "Pencil", _ 
     .[Date] = New DateTime(2012, 3, 1, 0, 0, 0), _ 
     .Price = 6.04, _ 
     .Quantity = 80 _ 
    }, _ 
    New Product() With { _ 
     .Name = "Pencil", _ 
     .[Date] = New DateTime(2012, 4, 1, 0, 0, 0), _ 
     .Price = 6.28, _ 
     .Quantity = 72 _ 
    }, _ 
    New Product() With { _ 
     .Name = "Pencil", _ 
     .[Date] = New DateTime(2012, 5, 1, 0, 0, 0), _ 
     .Price = 6.12, _ 
     .Quantity = 99 _ 
    }, _ 
    New Product() With { _ 
     .Name = "Pencil", _ 
     .[Date] = New DateTime(2012, 6, 1, 0, 0, 0), _ 
     .Price = 6.59, _ 
     .Quantity = 40 _ 
    }, _ 
    New Product() With { _ 
     .Name = "Pencil", _ 
     .[Date] = New DateTime(2012, 7, 1, 0, 0, 0), _ 
     .Price = 6.29, _ 
     .Quantity = 68 _ 
    }, _ 
    New Product() With { _ 
     .Name = "Pencil", _ 
     .[Date] = New DateTime(2012, 8, 1, 0, 0, 0), _ 
     .Price = 5.99, _ 
     .Quantity = 95 _ 
    }, _ 
    New Product() With { _ 
     .Name = "Pencil", _ 
     .[Date] = New DateTime(2012, 9, 1, 0, 0, 0), _ 
     .Price = 5.89, _ 
     .Quantity = 120 _ 
    }, _ 
    New Product() With { _ 
     .Name = "Pencil", _ 
     .[Date] = New DateTime(2012, 10, 1, 0, 0, 0), _ 
     .Price = 5.99, _ 
     .Quantity = 105 _ 
    }, _ 
    New Product() With { _ 
     .Name = "Pencil", _ 
     .[Date] = New DateTime(2012, 11, 1, 0, 0, 0), _ 
     .Price = 5.96, _ 
     .Quantity = 111 _ 
    }, _ 
    New Product() With { _ 
     .Name = "Pencil", _ 
     .[Date] = New DateTime(2012, 12, 1, 0, 0, 0), _ 
     .Price = 5.99, _ 
     .Quantity = 108 _ 
    }, _ 
    New Product() With { _ 
     .Name = "Notebook", _ 
     .[Date] = New DateTime(2012, 1, 1, 0, 0, 0), _ 
     .Price = 22.86, _ 
     .Quantity = 88 _ 
    }, _ 
    New Product() With { _ 
     .Name = "Notebook", _ 
     .[Date] = New DateTime(2012, 2, 1, 0, 0, 0), _ 
     .Price = 23.02, _ 
     .Quantity = 95 _ 
    }, _ 
    New Product() With { _ 
     .Name = "Notebook", _ 
     .[Date] = New DateTime(2012, 3, 1, 0, 0, 0), _ 
     .Price = 23.22, _ 
     .Quantity = 102 _ 
    }, _ 
    New Product() With { _ 
     .Name = "Notebook", _ 
     .[Date] = New DateTime(2012, 4, 1, 0, 0, 0), _ 
     .Price = 21.99, _ 
     .Quantity = 95 _ 
    }, _ 
    New Product() With { _ 
     .Name = "Notebook", _ 
     .[Date] = New DateTime(2012, 5, 1, 0, 0, 0), _ 
     .Price = 22.45, _ 
     .Quantity = 84 _ 
    }, _ 
    New Product() With { _ 
     .Name = "Notebook", _ 
     .[Date] = New DateTime(2012, 6, 1, 0, 0, 0), _ 
     .Price = 22.56, _ 
     .Quantity = 96 _ 
    }, _ 
    New Product() With { _ 
     .Name = "Notebook", _ 
     .[Date] = New DateTime(2012, 7, 1, 0, 0, 0), _ 
     .Price = 22.88, _ 
     .Quantity = 88 _ 
    }, _ 
    New Product() With { _ 
     .Name = "Notebook", _ 
     .[Date] = New DateTime(2012, 8, 1, 0, 0, 0), _ 
     .Price = 22.42, _ 
     .Quantity = 99 _ 
    }, _ 
    New Product() With { _ 
     .Name = "Notebook", _ 
     .[Date] = New DateTime(2012, 9, 1, 0, 0, 0), _ 
     .Price = 22.56, _ 
     .Quantity = 111 _ 
    }, _ 
    New Product() With { _ 
     .Name = "Notebook", _ 
     .[Date] = New DateTime(2012, 10, 1, 0, 0, 0), _ 
     .Price = 22.18, _ 
     .Quantity = 102 _ 
    }, _ 
    New Product() With { _ 
     .Name = "Notebook", _ 
     .[Date] = New DateTime(2012, 11, 1, 0, 0, 0), _ 
     .Price = 22.93, _ 
     .Quantity = 105 _ 
    }, _ 
    New Product() With { _ 
     .Name = "Notebook", _ 
     .[Date] = New DateTime(2012, 12, 1, 0, 0, 0), _ 
     .Price = 22.89, _ 
     .Quantity = 122 _ 
    } _ 
   } 
 
        Return PivotData 
    End Function 
End Class

See Also

In this article
Related articles
Not finding the help you need? Improve this article