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.
Similar to Excel - RadPivotGrid could have an area, where you can select some filter/group descriptions.
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
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.
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
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)
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.
A sample scenario where this will be useful is if you want to show both the absolute and percentage value of the cells.
