Hi All,
I am using MVVM, and display records in xamGrid. I applied groping on one column and display average values of all the columns, for this i use SummaryRowSettings. it is working fine but i want customization in display of records
1- Remove “Average” text from within cells and put in first Company Name column.
2- Add checkbox at top of table to "show average" or not.
3- Add dropdown at top of table to "show Formating" of AverageSummaryOperand percentage or integer, in sample application i used three static columns (RSquared , IndicatorPercentile ,OverUnderValuation) and other all columns are auto generated. All columns have FormatString is %. But i want customizable.
I create a sample application for this and add an image for reference i used same display records that shown in attached image in code, with the name of Portfolio.
Regards
Sufyan
And want to disable the Sum symbol in column header when groping is applied and average is displayed, to restrict user checking any item (e.g. Sum, Count, etc)
I have some null values in database and in grid these values are empty. When average is calculated i don't include these empty values in average calculations.Suppose i have 4 rows in one group and this group contains only one row value. Currently system calculated average like this, Sum of values of all the rows and divided by no of all rows. But i want sum of only those rows that contains values and divided by no of rows that contains values, not all rows, and do not show 0.00% if all rows are empty. I have attached image in previous sample application for further clarification.
Hello Sufyan,
Thank you for your post. I have been looking into it and I can suggest you create custom summary. Here you can see how to do so:
http://help.infragistics.com/NetAdvantage/Silverlight/2012.2/CLR4.0/?page=xamGrid_Create_a_Custom_Summary.html
In the steps a ServiceRefference is used, but you can change it with any collection you have.
Hope this helps you.
Hi Stefan,
I already seen this link but not progress. kindly modify my sample application according to this approach and solve my points that i mentioned. I shall be very thankful to you for this favor.
I have been looking into the screenshot you have attached and I modified your sample, so now it has the functionality you want. Basically I followed the steps from the link I provided you to create custom summaries. I also added checkbox and combobox per your requirements.
Thank you for your feedback. I am glad that you resolved your issue and I believe that other community members may benefit from this as well.
Thanks again.
Thank you so much. This solution solved my problem.
I have modified your sample, so now it works as you want.
Any update ?????
Any update about my issues.