Some of the most powerful features of the new RadPivotGrid are based around aggregates.  It would be great if you could simply sort by any aggregate fields set up, including Grand Totals.  I have not seen any documentation on doing this as it stands.

Hi,

At first I received the same error in this thread and applied the fixed as suggested. This works ok until I Edit Fields in the Designer. On saving the changes the OLAP settings are placed back into the code. I am then required to delete the code to fix this problem. I am constantly back-and-forth using Edit Fields while building my application.

I don't see this as a Feature Request as suggested in the thread, rather a Bug based on this behavior.

https://www.telerik.com/forums/pivotgrid-problem 

<OlapSettings>
<XmlaConnectionSettings Encoding="utf-8"></XmlaConnectionSettings>
</OlapSettings>

In RadPivotGrid control can be intresting have a Virtual scrolling and paging like RadGrid control.

The current RadPivotGrid handles sum, count, etc. but does not handle 'distinct count'.

To elaborate: a field contains numerous different values that are duplicated over a number of rows - 'distinct count' counts the number of distinct values in the record set.

Looks like someone has already submitted a similar question/request:
http://www.telerik.com/forums/count-distinct-aggregate

Hope it makes it into a future release. :-)

Many thanks,

It will be useful to have sorting feature in PivotGridAggregateField. For example as in attachment one may want to sort the grades of students as me :) 
Looking forward to have sorting feature in new releases. 

I have a scenario in my web application where I need possibility to sort values in RadPivotGrid by field existing in datasource, but is not displayed in RadPivotGrid.

For Example I have flats that should be sorted in order defined in field sort_order, I can add this field to RadPivotGrid, but I don't want to show it to user. 
This approach works perfectly with standard RadGrid, but unfortunately does not work with RadPivotGrid. Flats are sorted by their names, with is wrong from my point of view. 

Using RadPivotGrid with million and more records in data source, performance is very poor, and memory/CPU consumption/utilization goes very high. 

Is there a way to optimize data loading in this control?

The Telerik blog posting at http://blogs.telerik.com/xamlteam/posts/12-12-21/introducing-radpivotgrid-for-wpf-silverlight describes how to add "calculation" fields to a RadPivotGrid for WPF/Silverlight. As far as I can tell, the current version of RadPivotGrid for ASP.NET AJAX doesn't have this feature. Please add this feature to the RadPivotGrid for ASP.NET AJAX. I need it in order to add percentages to a RadPivotGrid similar to what is described in the Calculations section in the blog entry.

Would be good if ajax pivotgrid filter window supported OLAP dimension hierarchies

The Filter window / popup, doesn't seem to respect an OLAP dimension hierarchy.  It just shows a flat list at top level (for example case of date hierarchy just shows year).

See attached for a date hierarchy example in three different cube browsers, each with the same OLAP SSAS backend. Browsers are a) ajax pivot grid, b) kendo pivot grid and c) excel

The Ajax version just shows flat list, whereas kendo pivot and excel show the hierarchy

Thanks

Chris

When adding a calculated column to give you something like the Avg Price. The column appears across the whole pivot grid. So say you have your totalprice and qty showing for different stores. So the grid groups by stores. When you add the grandtotal calculation you get a new column added to each store.

I don't want the avg price added to each store .. I only want to see the average price in the grand totals section to the right?

Thanks.

The aggregates functions highlighted in the attached screenshots have common names that are used in the industry and as such they are not localized. This feature request is so that their names can be localized through global resx files along with other strings in the RadPivotGrid control.

In the meantime, you can use the ItemDataBound event to change cell texts based on your requirements. You can find similar examples here: https://demos.telerik.com/aspnet-ajax/pivotgrid/examples/appearance/conditionalformatting/defaultcs.aspx
For example, to change the Sum aggregate name in the column header, you can do this:
            else if (e.Cell is PivotGridColumnHeaderCell)
            {
                PivotGridColumnHeaderCell cell = e.Cell as PivotGridColumnHeaderCell;
                cell.Text = cell.Text.Replace("Sum ", "custom ");

The full stract trace of the error can be found in the attached file.

RadPivotGrid returns wrong results when a null-values-containing column is filtered.


Steps to reproduce:
1. Run the following code

2. Click the filter button on the second column and try to filter by "1" value

Result: the blank results only are shown.


<telerik:RadPivotGrid RenderMode="Lightweight" ID="TManagerGrid" runat="server" AllowFiltering="true"
            OnNeedDataSource="TManagerGrid_NeedDataSource"
            ShowFilterHeaderZone="true">
            <Fields>
                <telerik:PivotGridRowField DataField="NUM" UniqueName="NUM" ZoneIndex="10" SortOrder="Ascending">
                </telerik:PivotGridRowField>
                <telerik:PivotGridRowField DataField="SOURCE_LINE_ITEM" UniqueName="SOURCE_LINE_ITEM" ZoneIndex="11" SortOrder="Ascending">
                </telerik:PivotGridRowField>
                <telerik:PivotGridRowField DataField="SORTORDER" UniqueName="SORTORDER" ZoneIndex="12" SortOrder="Ascending">
                </telerik:PivotGridRowField>
                <telerik:PivotGridAggregateField DataField="NUM">
                </telerik:PivotGridAggregateField>
            </Fields>
        </telerik:RadPivotGrid>



    protected void TManagerGrid_NeedDataSource(object sender, Telerik.Web.UI.PivotGridNeedDataSourceEventArgs e)
    {
        TManagerGrid.DataSource = GetData();
    }

    protected DataTable GetData()
    {
        DataTable tbl = new DataTable();
        tbl.Columns.Add(new DataColumn("NUM"));
        tbl.Columns.Add(new DataColumn("SOURCE_LINE_ITEM"));
        tbl.Columns.Add(new DataColumn("SORTORDER"));

        tbl.Rows.Add(new object[] { "aa", 1, 20 });
        tbl.Rows.Add(new object[] { "bb", null, 30});
        tbl.Rows.Add(new object[] { "cc", 2, 50 });

        return tbl;
    }