Pivot Grid right fit for this?

[Patrick]

I've got data that looks like this from a DB:

FromSomething    ToSomething    Amount

place a                   place b             1.55

place d                   place b              2.33

place a                   place f               1.20

and so on .....

I need it to go in a matrix that looks like this:

                  place b           place f       place m

place a       1.33               1.25          .50

place b        0                   1.00          .25

 

I can't get this to work at all, using the pivot grid and configuring it like the Telerik demos site, using local binding.  The grid is blank.

Is the pivot grid right for this?  If so, how should it work?

[Georgi Krustev]

Hello Patrick,

Based on the given information, I suppose that PivotGrid will be able to build the required cross-tabular data aggregation that you are looking for.

If you are experiencing any difficulties with the setup, I would suggest you review our online demos and widget configuration (note that ASP.NET MVC wrapper will define exactly those options). If the problem still persists, please send us a repro demo that we will be able to review. Thus we will pinpoint the cause of the issue.

Regards,
Georgi Krustev
Telerik