Completed
Last Updated: 28 Jun 2019 04:27 by ADMIN
Created by: Tom
Comments: 3
Category: PivotGrid
Type: Feature Request
0
Hi I have a straightforward feature request: I would like to be able to "get" the row/column "filter" values the user has selected server-side. Basically need a public property or some type of getter. Currently on the PivotGrid, the row/column "Filter" "Includes/Excludes" can be "set" programmatically, but user selected values can't be easily gotten.

I would use it in a couple ways: 

1) to display context to the user for the numbers in the grid. (e.g., show the user the active filter values responsible for the numbers they are seeing in the PivotGrid Detail). 

2) I need the filter values to close Ticket 1168787.

A Telerik employee make a nice sample project to do drill-through functionality: https://www.telerik.com/blogs/how-to-implement-drill-down-functionality-in-telerik-s-pivotgrid-for-asp.net-ajax-part-2

But the PivotGrid counts and RadGrid detail data records returned are not in agreement because selected PivotGrid filters aren't applied to the detail returned in the RadGrid. I need to do that. I need to be able to mimic a drill through action into the detail records that make up the data counts. If I click a cell that says "100" (orders, 2018 year included) I need 100 orders returned in the detail. Not 7000 orders (all order years, unfiltered).

In that ticket, I'm trying to mimic the functionality similar to an SSAS "drillthrough action" (like many cube browsers have built in, e.g., RANET OLAP), except here with a regular SQL data source. This way I can drill into the detail records that make up the numbers displayed to the user in the PivotGrid. However, as it stands, the counts and detail will not be congruent until I can get the filter values selected by the user and apply them accordingly to the data set for the detail RadGrid. The BI users expect to be able to drill into the data and I need to provide it.

Thank you,

Tom


Pending Review
Last Updated: 16 Aug 2018 13:33 by Chris
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
Pending Review
Last Updated: 03 May 2018 18:04 by Imported User
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 ");
Declined
Last Updated: 24 Oct 2017 12:20 by Adam
Created by: Eli
Comments: 24
Category: PivotGrid
Type: Feature Request
27
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.
Approved
Last Updated: 23 Nov 2016 13:49 by ADMIN
Pending Review
Last Updated: 14 Nov 2016 13:21 by Subrat
Approved
Last Updated: 10 Oct 2016 11:49 by ADMIN
ADMIN
Created by: Angel Petrov
Comments: 0
Category: PivotGrid
Type: Feature Request
0

			
Completed
Last Updated: 30 Sep 2016 12:48 by ADMIN
PivotGrid: setting cell.CssClass to some class does not work for total cells but it does for data cells.
In Development
Last Updated: 26 Sep 2016 10:32 by Robert
Created by: Serdar
Comments: 1
Category: PivotGrid
Type: Feature Request
4
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. 
Approved
Last Updated: 22 Sep 2016 09:28 by Trilochan
Declined
Last Updated: 20 Sep 2016 07:13 by ADMIN
Created by: AndyRutter
Comments: 1
Category: PivotGrid
Type: Feature Request
1
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
Completed
Last Updated: 20 Sep 2016 06:52 by ADMIN
ADMIN
Created by: Konstantin Dikov
Comments: 0
Category: PivotGrid
Type: Feature Request
3

			
Completed
Last Updated: 20 Sep 2016 06:30 by ADMIN
ADMIN
Created by: Pavlina
Comments: 0
Category: PivotGrid
Type: Feature Request
0

			
Completed
Last Updated: 20 Sep 2016 06:29 by Marcin
Created by: Marcin
Comments: 0
Category: PivotGrid
Type: Feature Request
2
Add possibility to translate PivotGrid Total and Grand Total labels via RadPivotGrid.Main.resx file.
Completed
Last Updated: 20 Sep 2016 06:29 by ADMIN
ADMIN
Created by: Maria Ilieva
Comments: 0
Category: PivotGrid
Type: Feature Request
2

			
Declined
Last Updated: 29 Jul 2016 13:25 by ADMIN
Declined
Last Updated: 29 Jul 2016 13:24 by ADMIN
Created by: Warner
Comments: 1
Category: PivotGrid
Type: Feature Request
1
Would like to have the ability to remove and add items to a pivot grid's filter window prior to rendering.  Any item added or removed would be persisted/updated to the data-source.

Many requests come from vendors that require certain information to be provided or removed based on user privileges, business rules, user inputs, etc.. 

Declined
Last Updated: 29 Jul 2016 12:06 by ADMIN
ADMIN
Created by: Eyup
Comments: 1
Category: PivotGrid
Type: Feature Request
2
Aggregate functions like Max, Min and Count would be useful in some scenarios with fields of type DateTime.
Declined
Last Updated: 29 Jul 2016 11:45 by ADMIN
In an at least two level pivotgrid scenario, it would be nice to have the option of calculating the percentage of the inner level within that level and not based on the grand total (i.e. on the subtotal of the parent). In the attached image we can see that the inner levels have percentages based on the grand total instead of percentages of the category they belong. For example Diprivan should have a percentage of 100% since it is the only element of Astrazeneca. Same goes for Astrazeneca since it is the only element of Anesthetic, General.
1 2 3