Unplanned
Last Updated: 11 Sep 2020 12:00 by ADMIN
Created by: Paul
Comments: 0
Category: PivotGrid
Type: Feature Request
1

The RadGrid attachment shows the Data I need to present in the form of rows of Products each with a start date. 

HOWEVER, I need to present the data "per start date" so basically the Date would be a Column Header, then each date would show the duration, start time, and price under each Start Date. 

The PivotGrid attachment shows how I was able to take the same data and present it with the start date as a column but is not sufficient for my needs. I need to be able to Page by Start Date, so essentially a custom pager that keeps track of the Start Date and only shows like 3 days at a time. So in the screenshot you see Sept 9th through Sept 25, however I would like to have the pager control which rows are presented and then be able to page on the date column rather than showing the full month with a horizontal scrollbar.

Unplanned
Last Updated: 18 Jun 2020 16:20 by ADMIN
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 ");
Unplanned
Last Updated: 18 Jun 2020 15:05 by ADMIN
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
Unplanned
Last Updated: 01 Jun 2020 16:23 by ADMIN
Created by: Marcin
Comments: 2
Category: PivotGrid
Type: Feature Request
4
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. 
Unplanned
Last Updated: 23 Nov 2016 13:49 by ADMIN
Unplanned
Last Updated: 10 Oct 2016 11:49 by ADMIN
ADMIN
Created by: Angel Petrov
Comments: 0
Category: PivotGrid
Type: Feature Request
0

					
			
Unplanned
Last Updated: 22 Sep 2016 09:28 by Trilochan
Unplanned
Last Updated: 01 Jun 2016 11:26 by ADMIN
ADMIN
Created by: Daniel
Comments: 0
Category: PivotGrid
Type: Feature Request
0

					
			
Unplanned
Last Updated: 23 Mar 2015 08:11 by ADMIN
ADMIN
Created by: Maria Ilieva
Comments: 0
Category: PivotGrid
Type: Feature Request
1

					
			
Unplanned
Last Updated: 05 Mar 2015 09:27 by Ovais
Created by: Ovais
Comments: 0
Category: PivotGrid
Type: Feature Request
0
Add Caption/Title as property for the RadPivotGrid so if there is any need of adding a title/caption when user exports a file as excel sheet, we don't have any need of custom code. This newly requested property for Title should do the trick. This will ease the title/caption feature, and that is what telerik is all about 'EASE'.
Unplanned
Last Updated: 26 Aug 2014 12:40 by ADMIN
ADMIN
Created by: Maria Ilieva
Comments: 0
Category: PivotGrid
Type: Feature Request
0

					
			
Unplanned
Last Updated: 29 Apr 2014 16:03 by Benoit
ADMIN
Created by: Angel Petrov
Comments: 2
Category: PivotGrid
Type: Feature Request
3