One should be able to move the selected cell and scroll with the arrow keys. The attached project features a solution for moving the currently selected cell using the arrow keys.

Currently the AdomdDataProvider supports only AdomdClient version 10.0 which supports Microsoft SQL Server 2008. Add support for newer versions.

Add functionality which will allow the end users to edit the aggregated data. The new values should be passed back to the business logic of the application which will decide how to divide the new value across underlying records.

Hello,

I am using the pivot grid control would like to know if it is possible to add a start and end to the grouping?

My pivot grid looks like this: I would like the user to be able to specify a start and end for the grouping.

Excel has this option:

How can I replicate this functionality?

Currently, you can only copy the contents of the data cells to the clipboard and it is not possible to include the column/row header names.

As a user I want to hide the Grand Totals for specific groups:

Workaround: If possible add the label filters with code
PropertyGroupDescription dateGroupDescription = new PropertyGroupDescription();
dateGroupDescription.PropertyName = "Date";

LabelGroupFilter filter = new LabelGroupFilter();
ComparisonCondition condition = new ComparisonCondition
{
    Condition = Telerik.Pivot.Core.Filtering.Comparison.IsGreaterThan,
    Than = new DateTime(2010, 6, 6)
};
filter.Condition = condition;
dateGroupDescription.GroupFilter = filter;

this.provider.RowGroupDescriptions.Add(dateGroupDescription);

AutoSizeRows property which allows autosizing both header rows and data rows.

Currently the only way to recognize something changed as accurate as possible is to use StatusChanged on the DataProvider, but that does not tell apart from a structure change or just a click on the Update button… it would be nice to have such events available (onUpdate, onFieldListModified etc)

ADD. RadPivotGrid - add ability to filter by more than one condition - composite filters

ADD. RadPivotGrid - add single selection mode and expose the selected cell in property

Consider the pivot PivotGrid >> Binding With RadChartView example in our demo application. RadChartView shows all cells that are selected and there is no api to interpolate or filter them.

It should be possible to group the fields in the "Choose fields" are when using LocalDataSourceProvider because in some cases when you join a few tables, you might end up with a large number of fields.

To reproduce the problem, use the following setup for RadPivotGrid:

        public RadForm1()
        {
            InitializeComponent();

            DataTable table = new DataTable();
            table.Columns.Add("Name", typeof(string));
            table.Columns.Add("Salary", typeof(int));
            table.Columns.Add("Title", typeof(string));
            table.Rows.Add("John",1200,"Accountant");
            table.Rows.Add("Ana", 800, "Accountant");
            table.Rows.Add("Sam", 2500, "Manager");
            table.Rows.Add("Tom", 1300, "Manager");

            this.radPivotGrid1.RowGroupDescriptions.Add(new PropertyGroupDescription() { PropertyName = "Title"});
            this.radPivotGrid1.RowGroupDescriptions.Add(new PropertyGroupDescription() { PropertyName = "Name" });
            this.radPivotGrid1.AggregateDescriptions.Add(new PropertyAggregateDescription() { PropertyName = "Salary", AggregateFunction = AggregateFunctions.Sum }); 
         
            this.radPivotGrid1.DataSource = table;
        }

Follow the steps:

1. Filter the child group ("Name") >> Salary>1000.

This is the result of the applied filter:

2.  Filter the parent group ("Title") >> Salary>1500.

After applying the filter, the observed result is that the Accountant group is still displayed even though it should be filtered and hidden (like in Excel):

Observed result:

Expected result:

Workaround:

Use the new PivotGridSpreadExport

To reproduce: 

- Set the ExportFlatData property to true

- Export the grid using PivotExportToExcelML