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.