Hi All,
I have recently started exploring XamPivotGrid control & have some basic questions for same -
1. As we allow users to filter dimension values using "FilterFieldItemControl" tool. Is there a way to add visual indicator to identify all FilterFieldItemControl where "All Selected" checkbox is unchecked.
2. Want to add a search textbox in FilterFieldItemControl's drop down popup to select only filtered items instead of complete value list.
3. We like to show a single grandtotal row(do not want to show any subtotal) in XamPivotGrid. Can you tell me how we can implement this ?
4. We also want to show grouping in excel output which should be resemble of current schema of XamPivotGrid
We need answers of above queries on urgent basis based on which we can plan to include XamPivotGrid control in our strategic application.
Thanks
Lalit Dwivedi
Hello Lalit and thank you for your interest in XamPivotGrid!
Adding a visual indicator to the FilterFieldItemControl when the SelectAll checkbox is unchecked could be achieved by modifying the default style for the same. It is located in C:\Program Files (x86)\Infragistics\2015.1\WPF\DefaultStyles\XamPivotGrid\generic.xaml file. The IsChecked state of the checkbox that controls the select all feature is bound to IsAllSelected property so you can use its value to modify the template or handle the Unchecked event for the same. Modifying the same template would allow you to add custom elements to create the search functionality that you need as well.Regarding the totals hiding you may have a look at the following forum post that describes how the datarow’s IsTotal can be used to collapse some totals and the Tuple members to check the child count for the same: http://es.infragistics.com/community/forums/t/62761.aspx.I am not sure if I understand the forth question in the list. Are you exporting the grid to an Excel workbook? Do you need the same filters, groups applied in Excel in that case?