Controls / RadPivotGrid / Getting Started

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"&#13;                xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"&#13;                xmlns:telerik="http://schemas.telerik.com/2008/xaml/presentation"&#13;                xmlns:local="clr-namespace:RadPivotGrid_GettingStarted"
                xmlns:pivot="http://schemas.telerik.com/2008/xaml/presentation/pivot"&#13;                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