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
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
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
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!