Add support for Hours/Minutes/Seconds steps. Also, add a DayNumber option.
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.
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.
Currently it is only possible to either show all or hide all subtotals.
The DistinctValuesLimit property is available in our R1 2018 Release.
With the current implementation the top level header only visually appears as one cell, however it stretches the subheader column below (check PivotGrid(Now).png). Looking the attach file,now the XAML is following: <pivot:LocalDataSourceProvider.AggregateDescriptions> <pivot:PropertyAggregateDescription PropertyName="AccValue" CustomName="total"/> <pivot:PropertyAggregateDescription PropertyName="IncValue" CustomName="increased"/> </pivot:LocalDataSourceProvider.AggregateDescriptions> <pivot:LocalDataSourceProvider.ColumnGroupDescriptions> <pivot:PropertyGroupDescription PropertyName="SystemDeviceCode"/> </pivot:LocalDataSourceProvider.ColumnGroupDescriptions> the SystemDeviceCode column just use one column ,like the attach "PivotGrid(Now).png",when the text is long ,the first column "Total" is too wide . I hope like the attach "PivotGrid(desired).PNG",the SystemDeviceCode column can span two columns. and the data struct: public class DayStruct1 { public string HourNum { get; set; } public string SystemDeviceCode { get; set; } public double AccValue { get; set; } public double IncValue { get; set; } public DateTime Date { get; set; } }//