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.
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
If you open a label filter dialog from the RadPivotFieldList control for a DateTime field and choose the "is between" or "is not between" operator from the combobox, you will notice that the RadDateTimePicker controls used to filter the dates very small. In this case, the empty value placeholder is clipped and if you choose any dates they are clipped too.
To work this around, you can increase the dialog's width when it opens. You can do this with the RoutedDialogEvents.RequestDialog event.
public MainWindow()
{
InitializeComponent();
pivotFieldList.AddHandler(RoutedDialogEvents.RequestDialog, new EventHandler<DialogHostingRequestEventArgs>(this.OnDialogHostRequested), true);
}
private void OnDialogHostRequested(object sender, DialogHostingRequestEventArgs e)
{
var labelDialog = e.DialogInfo.Content as LabelFilterDialog;
if (labelDialog != null)
{
var w = labelDialog.ParentOfType<RadWindow>();
w.Width = 500;
}
}
It seems that the option to turn of sums has no effect for hirachie columns.
No matter if this option is checked or not, they do not disappear.
It works on regular columns.
Currently when you have null value in a cell, RadPivotGrid considers it as 0. This way when you apply some Aggregate Functions, like Average for example, the result may not be as expected. For example if you have the cells 10, null, 10 RadPivotGrid will show as total the value 6.67 (for Average function). You should be able to exclude null values, so the value 10 will be shown as average for the mentioned cells. Available in the 2016 R2 release.
Implement: "% of Parent", "% of Parent Row", "% of Parent Column"