I hadn’t yet given it a lot of thought with regards to the Xceed Grid.
I suppose it might work something like your built-in grouping, except that you would drag columns to be either “row values”, “column values”, or “data values”, in a very similar fashion to a pivot table in Excel. So you would add the data to the Xceed Grid first as normal, then manipulate it afterward. The best working example would be to try this in Excel with an arbitrary group table of data.
You may know this already, but Excel pivot tables are extremely useful ways of manipulating data, and are often heavily employed when making sense of large sets of risk/pricing data in the finance world.
Imported from legacy forums. Posted by IdleHand (had 3812 views)