Hi, I've a complicated requirement for Xamgrid grouping and summary row:

I've below data:

Store,Product,SizeS,SizeM,SizeL

s1, p1, 1,2,3

s1, p2, 3,2,4

s2, p1, 4,5,3

s2, p2, 7,5,3

now, I want to show this data in xamgrid with summary & group.

I grouped the data on Store, so, it looks like (expanded):

v s1

 Store,Product,SizeS,SizeM,SizeL

 s1, p1, 1,2,3

 s1, p2, 3,2,4

v s2

 Store,Product,SizeS,SizeM,SizeL

 s2, p1, 4,5,3

 s2, p2, 7,5,3

But, I want it to be shown like:

store, sizeS, sizeM, SizeL

>s1, 4,4,7

>s2, 11,10,6

(notice, the figures are Sum of sizes)

here  ">" show its expandable. and upon expanding first store:

store, sizeS, sizeM, SizeL

v s1, 4, 4, 7

  product, sizeS, SizeM, SizeL

  p1, 1,2,3

  p2, 3,2,4

>s2, 11,10,6

Any pointers, pls??