How can i create a grid with summary row

Hello Professionals,

I'm wondering how could i create a grid like the grid below, i want to create a grid with summary row,

i have tried to create it using collapsing but it didn't work as required.

Any suggestions?, i want to know just the starting point so i can make deep investigations.

Thanks in Advance,