Unplanned
Last Updated: 28 Feb 2024 13:58 by ADMIN
Created by: LindenauAtSOG
Comments: 6
Category: PivotGrid
Type: Feature Request
4

The caption sounds ocnfusing, but i couldn't come up with a better one:

Problem is, if you have hirarchical data like Date.Calendar, you have "sub" values that can be collapsed and expanded


Problem is, when you have more headers, that sit below therese hirarchies, they will be collapsed too.
In this example, "Category" sits below there.

See how the Category is not visible, because Icollapsed the whole year 2010.
Compare that to 2011 where all categories are visible, because its fully expanded.





The feature I am requesting here is to still be able to show columns for each category and aggregated values, even though the year is collapsed.
I know this would be acchieved by moving category on top of the headers, but this also changes orders of the columns.

Our old windows forms pivot grid had this kind of functionality.


MSPaint to the rescue, this is how I imagine it (ignore the numbers, they do not make sense)

Unplanned
Last Updated: 24 Jul 2023 10:30 by Stenly
Created by: Stenly
Comments: 0
Category: PivotGrid
Type: Feature Request
4
Currently, the RadPivotGrid does not support reordering the columns and rows groups. We could add support for such functionality similar to the one present in Excel.
Unplanned
Last Updated: 26 Jun 2023 07:58 by Stefania
Add average/min/max built in functions for DateTime and TimeSpan values
Completed
Last Updated: 24 May 2023 06:50 by ADMIN
Release R2 2023
ADMIN
Created by: Kalin
Comments: 0
Category: PivotGrid
Type: Feature Request
9

			
Completed
Last Updated: 23 May 2023 07:30 by ADMIN
Release R2 2023
When a label filter is applied and there are repeating groups for columns and rows the GetUnderlyingData method does not return the correct items. 
Unplanned
Last Updated: 04 May 2023 15:16 by Martin Ivanov
Currently, RadPivotGrid supports UI-based selection, which highlights the selected cells. However, the API that handles this is internal and it cannot be used to manually access the selection. Add API that allows to get the selected items and to update the selection.
Completed
Last Updated: 09 Mar 2023 08:26 by ADMIN
Release R1 2023 SP1
The TotalFormat of a calculated field can be transferred to its required field when both fields are used as aggregate values.
Unplanned
Last Updated: 06 Mar 2023 09:32 by Stenly
Add API to ignore null values when using the Drill Down functionality
Completed
Last Updated: 19 Jan 2023 14:50 by ADMIN
ADMIN
Created by: Rosen Vladimirov
Comments: 0
Category: PivotGrid
Type: Feature Request
5
RadPivotGrid is loading all data from OLAP Cube. It should be able to use on demand (lazy loading) pattern, so when a group is expanded, a new query is sent and only required data is taken from the server.
Completed
Last Updated: 17 Nov 2022 06:08 by ADMIN
Release LIB 2022.3.1121 (21 Nov 2022)
If we apply a label GroupFilter to a RowGroupDescription/ColumnGroupDescription (through the GroupFilter property or through the RadPivotFieldList) matching groups from both the rows and columns are filtered out. 
Completed
Last Updated: 21 Sep 2022 10:59 by ADMIN
Release LIB 2022.3.926 (26 Sep 2022)
Created by: Grinden
Comments: 0
Category: PivotGrid
Type: Feature Request
2
If you apply a number format to a Count value in the RadPivotGrid, then it is ignored. The reason given is that count is always an integer, so it shouldn't need formatting. However, I'd like to be able to apply group separators. It's much easier to read 100,000,000 than 100000000. 
Completed
Last Updated: 05 Aug 2022 12:11 by ADMIN
Release R3 2022
ADMIN
Created by: Rosen Vladimirov
Comments: 3
Category: PivotGrid
Type: Feature Request
22
Similar to Excel - RadPivotGrid could have an area, where you can select some filter/group descriptions.
Unplanned
Last Updated: 16 Jun 2022 09:45 by Martin Ivanov

Currently, the string format (used in the cells generated for the  from the DateTimeGroupDescription) is determined automatically based on the selected Step (Day, Month, etc.). Add an option to easily set custom string format.

At this moment, you can change the format only if you create a custom description and override a considerable amount of code. This is shown in the following SDK example: https://github.com/telerik/xaml-sdk/tree/master/PivotGrid/CustomDateTimeGroupDescription

 

Won't Fix
Last Updated: 02 Jun 2022 15:14 by ADMIN
InvalidOperationException regarding QuickStyle Freezable is thrown when the control is opened in new STA thread.
Completed
Last Updated: 13 Apr 2022 09:17 by ADMIN
Release LIB 2021.3.1025 (25 Oct 2021)
Created by: LindenauAtSOG
Comments: 12
Category: PivotGrid
Type: Bug Report
4
Bug can be reproduced in PivotGrid => Olap Support in demo application.
Under all main categories in the designer, there is a folder called "Sets" that has the exact same content.

It either is mistakingly placed under each "category" or should be something that sits on top of them in a more global fashion.

Completed
Last Updated: 17 Mar 2022 07:23 by ADMIN
Release LIB 2022.1.321 (21 Mar 2022)
InvalidDataContractException is thrown when serializing the LocalDataSourceProvider with a DataContractSerializer and a calculation (TotalFormat) is applied.
Unplanned
Last Updated: 30 Dec 2021 10:42 by ADMIN
Currently, changing the visibility of the Expand/Collapse icon, via style, will apply it to all of the elements which are of type PivotGroupHeader.  
Completed
Last Updated: 20 Dec 2021 12:54 by ADMIN
Release R1 2022
ADMIN
Created by: Georgi
Comments: 6
Category: PivotGrid
Type: Feature Request
3
add a textbox which allows users to find matching distinc values when using report filters. Very valuable if you are dealing with many distinct values. 
Unplanned
Last Updated: 14 Dec 2021 15:22 by ADMIN
Currently - any string can be typed in the combobox which is displayed as the editor for the label filters. The input should be limited to only the values present in the ItemsSource collection. 
Completed
Last Updated: 14 Dec 2021 15:22 by ADMIN
Release LIB 2021.3.1004 (4 Oct 2021)
Created by: LindenauAtSOG
Comments: 10
Category: PivotGrid
Type: Bug Report
4

Bug can be observed in Pivot Grid => Olap Sorting example in  the most recent demo.

Sadly i do not know what this menu is called in english (and the demo cannot change language) so here is a screenshot



Set it to 'Equal' 'Lisa Cai'




If you hit ok and refresh, all values are gone.
Weirdly if you change it to not equal, you still get zero results



1 2 3 4 5 6