Hi Telerik Team,

I want to make a hierachy in PivotGridColumnField as in screenshot (pivotgrid_desired.png). I made a GradeBook project. It holds Student Names, Exam Names,Parent Exam Names, and Grades as in ( gradebook.rar ) . My pivotgrid screenshot is in ( pivotgrid.png ). I googled and read PivotGrid online documents but I couldn't find how to make hierarchy  in columns as  (pivotgrid_desired.png). 

Looking forward for your solution.

Thanks.

Aggregate functions like Max, Min and Count would be useful in some scenarios with fields of type DateTime.

Add possibility to translate PivotGrid Total and Grand Total labels via RadPivotGrid.Main.resx file.

Currently, you have ColumnGroupsDefaultExpanded and RowGroupsDefaultExpanded available for the PivotGrid.

I would like to request an ExpandedGroupsBehavior that allows you to set a particular level to expand to.

To better explain this, the WPF PivotGrid has this. Here is a the documentation: http://docs.telerik.com/devtools/wpf/controls/radpivotgrid/features/expand-behavior.html

Thank you

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;
    }

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

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 ");

If you call Page.DataBind() in the Page_Load event handler of a page that has a RadPivotGrid on it that has an event handler for OnNeedDataSource, the OnNeedDataSource event isn't raised when the page is loaded. This behavior is different than that of other controls such as RadGrid. In my opinion it is confusing and the behavior should be the same. You may have other controls on the page that you want to data bind. So, I think it is reasonable that you should be able to call DataBind() and use advanced binding with RadPivotGrid at the same time. Also, I noticed that if you don't call DataBind(), the OnNeedDataSource event is raised twice.

Please see the Visual Studio 2012 project that I attached to this bug report for example code. Set break points in the NeedDataSource event handlers for the RadPivotGrid and RadGrid controls and run the application in debug mode to see the behavior. Comment and uncomment the call to DataBind() in Page_Load().

Add increased customisation opportunities to the Configuration Panel in the RadPivotGrid:
Allow sorting of "All Fields"
Allow addition of fields to "All Fields" collection without adding to Filter / Row / Group / Aggregate Zones
User specified dimensions of Filter / Row / Group / Aggregate sections

As stated in the title: in RadPivotGrid, user should be able to drag and drop fields directly to row / aggregate / filter fields without having to check them first in the configuration panel. See attached image.

In current situation, user has to (a) first check the box to move the field to e.g. row fields and THEN to drag it to the order they want - this is TWO postbacks.
If this feature was implemented, users could drag the field from the config. panel and drop it directly in the place they want - only ONE postback.

Dragging and dropping is by far the most intuitive way of doing things in the pivot grid (what is "Move to row fields" supposed to mean to an average user???) so please consider this. It is a strikingly missing feature.

Can you please add other type of exports to the Ajax pivot grid.  The excel export is really good but it would be great to have a native pdf and csv export.