Hi,

I wanna use hierarchical webGrid, where the parent and the child table have few shared columns.

Actually the parent table contains total quantities for products and the child table gives drill down to the sub-products' quantities, so the total sum  each column in the child table is the quantity of the parent row of that table for the same column. Therefore, the columns of the parent table are the same of the child's columns.

For example: (Prod1 and Prod2 are from the parent table and the sub_ProdX_y are from the children table)

Product              |   Sunday  |    Monday |      Tuesday   ............

Prod1                           20                 50               100

sub_Prod1_1             15                  30                 50

sub_Prod1_2               5                  20                 50

Prod2                         40                  200              30

sub_Prod2_1              10                  10               10

sub_Prod2_2               10                150              10

sub_Prod2_3              20                  40                10

So, I want all of the total and sub quantities of the same day to appear in the same columns

Please advice

Thanks

Maya