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)

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

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.

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)

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....

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

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.

I would like RadPivotGrid to sort the dates defined in OLAP Cube as dates, for example:
-Week 1 -Week 2 -Week 12   Instead of the current sorting: -Week 1 -Week 12 -Week 2

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

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. 

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. 

 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.

When a label filter is applied and there are repeating groups for columns and rows the GetUnderlyingData method does not return the correct items. 

The DistinctValuesLimit property is available in our R1 2018 Release.

Available in LIB version 2016.2.606, it will be also available in the 2016 R2 SP1 release.

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. 

 Implement: "% of Parent", "% of Parent Row", "% of Parent Column"