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