Hi

To provide data to XamPivotGrid you should create DataSource that XamPivotGrid can read. Such oblects are  FlatDataSource and  XmlaDataSource. The first type is used when you have IEnumerable and want to show this data in the grid. The second type is used when you have analysis server as MS SQL Analysis server 2008.  In your case you should FlatDataSource. Below is the code you can use to provide your data:

List<Data> data = new List<Data>();

data.Add(new Data

{

    Date = DateTime.Parse("1/1/2000"),

    Ticker = "IBM",

    Value = 1.0

});

FlatDataSource flatDataSource = new FlatDataSource

    {

        ItemsSource = data,

        Cube = DataSourceBase.GenerateInitialCube("Data"),

        Rows = DataSourceBase.GenerateInitialItems("[Date]"),

        Columns = DataSourceBase.GenerateInitialItems("[Ticker]"),

        Measures = DataSourceBase.GenerateInitialItems("Value")

    };

pivotGrid.DataSource = flatDataSource;

The cube is your class that contains properties with data – here is “Data”. For rows and columns you should provide properties whose data will be shown in rows or in column and for measure you provide property with data for cells. Finally you have to assign XamPivotGrid’s DataSource samples. In addition you can use HierarchyDescriptor<Data>  to customize the look of the data in rows, columns and cell. You can see more complex sample about HierarchyDescriptor here http://labs.infragistics.com/silverlightdv/2010.2/#/Samples/PivotGrid/Basic/DataSourceFlatDataCB

Regards 

Todor 

Thank you so much. This is what I wanted. I have one doubt in this, if I want to display the products  as Measures then how it can be done?. Actually I have one  string property named as 'Product" under Pane class. I would like to add this Product to Measures. I am not able to add string parameters to Measures.Then how to do Compact Layout like as below.

2/ The second variant is: 

If you don’t want totals you should change data source like bellow and don’t add hierarchy descriptor:

FlatDataSource flatDataSource = new FlatDataSource()

            {

                ItemsSource = panes,

                Cube = DataSourceBase.GenerateInitialCube("Pane"),

                Columns = DataSourceBase.GenerateInitialItems("[Price],[Units]"),

                Rows = DataSourceBase.GenerateInitialItems("[Geography],[Product]"),

                Measures = DataSourceBase.GenerateInitialItems("Value")

            };

This code produce the follow picture:

 3/ the third variant is:

If you want each price to have different currency you should define 3 measures. And the code should be like this:

    public class Pane

    {

        public string Geography { get; set; }

        public string Product { get; set; }

        public string Price { get; set; }

        public double Price1 { get; set; }

        public double Price2 { get; set; }

        public double Price3 { get; set; }

    }

    panes.Add(new Pane { Geography = "Household", Price = "Price", Product = "Rinse Conditioners", Price1 = 22, Price2 = 33, Price3 = 44 });

    panes.Add(new Pane { Geography = "Household", Price = "Price", Product = "Main Wash", Price1 = 22, Price2 = 33, Price3 = 44 });

    panes.Add(new Pane { Geography = "Household", Price = "Price", Product = "Deodorants", Price1 = 22, Price2 = 33, Price3 = 44 });

    panes.Add(new Pane { Geography = "Household", Price = "Price", Product = "Tumble Drying Enhancer", Price1 = 22, Price2 = 33, Price3 = 44 });

    panes.Add(new Pane { Geography = "Household", Price = "Price", Product = "Iron Enhancer", Price1 = 22, Price2 = 33, Price3 = 44 });

    panes.Add(new Pane { Geography = "Household", Price = "Price", Product = "Wash Treatmentr", Price1 = 22, Price2 = 33, Price3 = 44 });

    panes.Add(new Pane { Geography = "Household", Price = "Price", Product = "Iron Enhancer", Price1 = 22, Price2 = 33, Price3 = 44 });

    panes.Add(new Pane { Geography = "Grocery Outlets", Price = "Volume", Product = "Rinse Conditioners", Price1 = 22, Price2 = 33, Price3 = 44 });

    panes.Add(new Pane { Geography = "Grocery Outlets", Price = "Volume", Product = "Main Wash", Price1 = 22, Price2 = 33, Price3 = 44 });

    panes.Add(new Pane { Geography = "Grocery Outlets", Price = "Volume", Product = "Deodorants", Price1 = 22, Price2 = 33, Price3 = 44 });

    panes.Add(new Pane { Geography = "Grocery Outlets", Price = "Volume", Product = "Tumble Drying Enhancer", Price1 = 22, Price2 = 33, Price3 = 44 });

    panes.Add(new Pane { Geography = "Grocery Outlets", Price = "Volume", Product = "Iron Enhancer", Price1 = 22, Price2 = 33, Price3 = 44 });

    panes.Add(new Pane { Geography = "Grocery Outlets", Price = "Volume", Product = "Special Wash", Price1 = 22, Price2 = 33, Price3 = 44 });

    FlatDataSource flatDataSource = new FlatDataSource()

    {

        ItemsSource = panes,

        Cube = DataSourceBase.GenerateInitialCube("Pane"),

        Columns = DataSourceBase.GenerateInitialItems("[Price]"),

        Rows = DataSourceBase.GenerateInitialItems("[Geography],[Product]"),

        Measures = DataSourceBase.GenerateInitialItems("Price1,Price2,Price3")

    };

    CubeMetadata cmd = new CubeMetadata { DataTypeFullName = typeof(Pane).FullName };

    cmd.DimensionSettings.Add(new DimensionMetadata { DisplayName = "Price1", SourcePropertyName = "Price1", DisplayFormat = "${0}" });

    cmd.DimensionSettings.Add(new DimensionMetadata { DisplayName = "Price2", SourcePropertyName = "Price2", DisplayFormat = "£{0}" });

    cmd.DimensionSettings.Add(new DimensionMetadata { DisplayName = "Price3", SourcePropertyName = "Price3", DisplayFormat = "{0}" });

    flatDataSource.CubesSettings.Add(cmd);

    pivotGrid.DataSource = flatDataSource;

The result is below: