Hi,
1) We would like to be able to sort on tennors (eg. 5 years, 3 months, 10 days). The data comes in as (2Y, 1Y,6M, 3M, 1M, 10d, 5d, 1d etc) Is it possible to apply a custom sort. I have attached an example screenshot with year tennors as they appear. In the example below we would like it to be (60Y, 50Y, 40Y, 30Y .....etc).
2) Additionaly we would like to enable to user to reposition the Currency columns or product rows similar to the Field Chooser drag drop indexing in the XamDataGrid. How would we go about providing such functionality.
3) Finally we would like to display "N/A" for measures that are aggregated. In our case we don't want to show data if it is aggregated. Therefore we only want to show data when the user has drilled down to a result count of 1. I can see that we can specify an aggregation calculation to be Count and can see which cells are made up of more than one value, however how can we display the value only when it is not an aggregate, otherwise "N / A". Many Thanks
Hello,
The following help topic explains how to implement custom sorting in the XamPivotGrid:
http://help.infragistics.com/Help/NetAdvantage/WPFDV/2011.1/CLR4.0/html/xamPivotGrid_DV_Sorting_Rows_and_Columns.html
Please let me know more about your request 2. I believe custom ordering the columns would be a feature request. Please give me precise information on how you would like this to work for your users.
Finally for request three, I am unsure what functionality you are looking for since the Pivot Grid is designed to show aggregated values which can then be drilled into. In your case it would sound as if you would want the Grid fully expanded so that all the values are displayed.
Valerie
Hi Valerie,
Thanks for the reply, adding a hierarchy and sort expression did the job.
I will get back to you regarding request 2, we are currently evaluating if it is a necessity for the users.
Regarding point 3, we are using the pivot grid to display market data therefore total rows/columns and aggregations do not make sense. I have found a way to remove the total rows and columns but was wondering if there was a simple way to always have the pivot grid in fully expanded mode.
Secondly our scenario is as follows:
Regards,
Nick
Hello Nick,
You should sort the datasource before assigning it to the grid.
Sincerely,ValerieDeveloper Support Engineer Infragisticswww.infragistics.com/support
Our datasource sort is getting more and more complicated as we want to sort more than one field at a time. The custom sort functionality in 11.1 used to work perfect for us and i am surprised that it was taken out. Is this a bug that will be resolved in future updates as we found the custom sort per field very useful.
Regards,Nick
There have been requests for this functionality, therefore we will be adding this back in the next service release for 11.1 and 11.2 with some changes.
The DataSourceBase.PreserveMembersOrder property will be changed to public with a default of true. Therefore you will need to set this property to false to use the OrderByKeyExpression.
Here are more details on the changes from engineering:
1. DataSourceBase.PreserveMembersOrder property is changed to be public with default value of true, that provides the same behavior we have with the current implementation.
2. This behavior can be overridden for specific levels as adding a LevelSortDirection instance to DataSourceBase.LevelDefaultSortDirections collection; that will change the initial appearance of these levels
<olap:FlatDataSource.LevelDefaultSortDirections> <olap:LevelSortDirection LevelUniqueName="[Date].[Date].[Years]" SortDirection="Descending"/> <olap:LevelSortDirection LevelUniqueName="[City].[City].[City]" SortDirection="Ascending"/> </olap:FlatDataSource.LevelDefaultSortDirections>
3. When DataSourceBase.PreserveMembersOrder is set to false, the initial direction depends on DataSourceBase.LevelFirstSortDirection value, unless the sort direction is specified using DataSourceBase.LevelDefaultSortDirections collection
This feature will be available for both flat data and XMLA.
Please let me know if you have any questions.
Thanks for the update. Looking forward to trying it out once it gets released.
We are using version 11.1.20111.2053 and I would like to know whether the sorting works in this version or not. From what I see it doesnt but I need to make sure it isnt just my code is wrong.
We cannot easily upgrade to the next service release or indeed 11.2 as we get some problems after the upgrade that I havent had time to fix, so for the moment we need to stick to that release.
Thanks,Doug Rees
Ralph Lauren.
Hello Doug,
If you have added sorting criteria to your HierarchyDescriptor and you have enabled row/ column sorting then when you click the sort indictor the columns /rows should be sorted based on the sort expression you have defined for the hierarchy. I tested this in 11.1 build 2053 and the columns / rows where sorted correctly after pressing the sort indicator.
Sincerely,
Developer Support Engineer
Infragistics
www.infragistics.com/support