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?