Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • User (Old forums)
    Member
    Post count: 23064
    #14137 |

    Hi, I don’t suppose there is anyway to use the Xceed Grid to perform Excel-like pivot table operations? About to embark on implementing this myself, so thought I would ask.

    Imported from legacy forums. Posted by IdleHand (had 2824 views)

    Odi [Xceed]
    Spectator
    Post count: 426

    There’s no built-in functionality like that, nor coming anytime soon. Can you please describe, briefly, how you envision this working?

    Imported from legacy forums. Posted by Odi [Xceed] (had 284 views)

    User (Old forums)
    Member
    Post count: 23064

    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)

Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.