Grid / Displaying Pivot Data

This example demonstrates how Telerik RadGrid can be bound to pivot table. This is especially useful when you want to display the data in a reverse order but still keep the same presentation and structure in the source table. The logic resides in the PivotTable method in the code-behind of the page which transforms the table rows into columns and the table columns into rows in the rendered grid.
Note, however, that features like paging, sorting, grouping, filtering, etc. will behave in a different way because the type of the data in the grid columns can vary (for example integers, strings, dates, etc.). This is due to the "vertical grid" effect. That is why sometimes they may return unexpected results and you should consider whether to enable them or execute your custom logic to manipulate the data in the grid.