Transform/pivot data (aka crosstabs)

[Manuel]

I'm trying to display (and let the user modify) some values which are best
displayed in a crosstab form.
Ex:
I have the following information:

StoreName - StoreID - StoreSize - ProductID - ProductName - QtySold
Joes Cafe - S1 - 100 - P1 - Eggs - 20
Joes Cafe - S1 - 100 - P2 - Ham - 25
EatALot - S2 - 120 - P1 - Eggs - 50
EatALot - S2 - 120 - P2 - Ham - 55

From that data, I want to present the user the followin table:

- Joes Cafe - EatALot
Store Size - 100 - 120
Eggs Sold - 20 - 50
Ham Sold - 25 - 55

And let the user modify the numbers.

I need some help over here! =(

 

[Guest]

Hi Manuel,

The data you put in this posting seems like a representation of a
5-dimension cube of sales data. You are probably looking at designing more
functions than simply pivoting (e.g. drilling, aggregations, dimension
selection, etc..; like OLAP analytical tools are doing).

As for a sample on transposing the data matrix that is rendered by the
datagrid, you can try JavaScript, like I did in this example
http://www.societopia.net/Samples/DataGrid_Pivot.aspx