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
--
HTH,
Phillip Williams
http://www.societopia.net http://www.webswapp.com
"Manuel" wrote:
[color=blue]
> 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! =(
>
>
>[/color]
