Add support for frozen columns. Like in RadGridView or Excel. This way you can scroll the data horizontally while part of the columns are frozen and you can always see them.

We can also consider adding frozen rows like in RadGridView or Excel.

If a group has only one item in it, I only want to show the total row and not being able to expand it.

Allow filtering through filtering icons in the headers as in the RadGridView control and the WinForms RadPivotGrid.

 Create search functionality in the fields section of the RadPivotFieldList. 

As a user I want to hide the Grand Totals for specific groups.

Bug can be observed using the Demo => PivotGrid => More OLAP Examples

Setup like so and hit refresh


A customer reported this issue. We could observe that the memory of the process was exploding, this doesnt happen in the demo for some reason.
Using the old RadarSoft  WinForms Pivot Control, the same view that our customer had issues with, is loading in a reasonable time.



Please also make sure that in future releases you add some cancel functionality so one doesn't have to restart the application....

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)

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.

Add API to ignore null values when using the Drill Down functionality

Currently when a header value is empty the displayed text is "(blank)" regardless of the application's culture. Localize this value or allow the developer to set this value more easily.

If you want to manually localize the "(blank)" text you can define a RowHeaderTemplate and ColumnHeaderTemplate (or template selector) and replace the default text with its translation. You can do that via IValueConverter.
(http://docs.telerik.com/devtools/wpf/controls/radpivotgrid/styles-and-templates/templating-cells#using-custom-cell-and-header-templates)

As a user I would like QueryableDataProvider to avoid blocking the UI while executing the query on the database server.

 When there are a lot of items, it is quite difficult to find the ones you need in RadPivotFieldList. There could be some way to search within the properties.

In the RadPivotGrid:
Open the Label Filter dialog on a dimension, don't set anything and press OK, then all items are present and nothing is filtered out as expected.
Open the Label filter again and manually specify that the value must equal "xyz" and click OK then it will exclude every item that doesn't match this. Again, this behaviour is what you'd expect.
If you then open the dialog, and delete the "xyz" from the textbox so that the dialog appears exactly as it did originally, and click OK then you won't see any items in your pivot grid. This is because it is now filtering out anything that doesn't have an empty string as the label. This is not what I'd expect.
To remedy this, you can click on the dimension and see that the Label filter is still ticked in the context menu, and click "Clear filter", but this isn't exactly intuitive. 
I'd like the filter to be cleared when you clear the text in the box.