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 Nick,
What is the version of 11.1 you have? The 11.1 RTM uses the custom sort by default and the order of items in the collection doesn’t matter. Since 11.1 SR1 we restored the earlier behavior where by default members appear in the order they are added to the collection.
Regards,
Plamen.
Hi Valerie,
Thanks for your reply, regarding the sorting problem i am attaching a simple VS app that demonstrates how custom sort works correclty in 11.1 and does not in 11.2. When you run the app the Infragistics references are for 11.2 and the tenors appear in the order they are added to the collection. If you then change all the Infragistics references to 11.1 you will notice that the custom sort now works and the items are sorted correctly. Why is this not working in the same way for 11.2?
Regards,Nick
Nick posted a question above regarding sorting not working in the new release of the xamPivotGrid. We are also experiencing this problem. Psease could you investigate.
Cheers
SCott
Hello,
You can use the CellControlAttached event to define conditional formats. Please see
http://help.infragistics.com/NetAdvantage/DV/2011.1/CLR4.0/?page=xamPivotGrid_US_Conditional_Formating.html
for more information.
Sincerely,
Valerie
Developer Support Engineer
Infragistics
www.infragistics.com/support
In the screenshot i attached on the first post you can see products Swap and Basis Swap, we would like to allow the user to define a format mask for Swap (e.g. 4 decimal places), but a different format mask (e.g. percentage) for Basis Swaps. What is the easiest approach to apply conditional formatting based on one of the properties of the databound object (in our case Product Type)?
Thanks,
Nick