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
This is an example of what I am trying to do.
The itemsource here is a list<myObject>.
Right now its rows are grouped by mygroups and index. What I want to achieve is to sort the data in each column based on the ordering of the index. The Index represents an index object which has a String label (displayed) and a int value which is value used for sorting. Index object implements iComparer and the compare method compares the int value.
WHat I have been trying to achieve but not asuccessful so far :
1. Enable sorting on rows. I can click on the date and sort the items in a column, but I cannot sort the column based on another dimension.
2.if I click on Index to sort the data, the data is still sorted based on its value in the entire column. But I will need it to sort based on the custom compare method.
Thanks!
Hello,
Here it is a working documentation link:http://help.infragistics.com/NetAdvantage/WPF/?page=xamPivotGrid_Sorting_Rows_and_Columns.html
If you require any further assistance, please do not hesitate to ask.
Regards,Plamen
Hi
I have a similar question and it seems that the link given about no longer exist.
Let me explain my question:
I have a pivot grid and I would like to have a field to be assigned as the row:
dataSrc.Rows=DataSourceBase.GenerateInitialItems("[index].[index]");
And I would like to Sort the MEASURE of the pivot data by index- but not by the value of the measure- which is what it is doing now.
And also the index class implements iComparable so that the comparison should be done based on a field in the index object.
Basically I want to know how can I tell the grid to sort the measure not based on the value but based on index? And how to trigger the icompare of the index object during sorting.
I have put Grid1.AllowHeaderRowsSorting=true but this does not make any difference.
Please Advise.
Thanks
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.
Please let me know if you have any questions.
Sincerely,
Valerie
Developer Support Engineer
Infragistics
www.infragistics.com/support
Hi Valerie,
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.