Hi,
I need to have a grid which can simulate the pivoting behavior of a pivot grid. I know Infragistics does not have a pivot grid in Winforms, but would like to know if such a thing can be implemented using the WinGrid.
In the snapshot attached, pivoting has been done on 2 columns "Designation" and "Age". The remaining columns can either show the count of values or the sum of values.
Hoping for your help,
Thanks and regards,
Nihar.
Nihar,
Another alternative would be to host the WPF XamPivotGrid in your windows forms application using the ElementHost. Would this work for you?
Hi Nihar,
The grid doesn't have any functionality to do pivoting. If you are binding the grid to a flat table of data, then the closest thing you could do would use to use OutlookGroupBy and group by the same two fields.
If you are more concerned with getting as close as possible to the look of the data that you have here, then you would have to bind to the grid to a data source that has the data in the structure in which you want it in the grid.