Subtotals without Matrix using Standard Table

[sscanlon]

Hi, hoping there is a way to achieve my end state, I use Matrix visuals already but do not believe I can use it for this scenario. 

My table is below - I am blanking out the data in middle. 

I would like to "Group" by Sales Person, and have a subtotal for each of them.

Each time I try to do this in a Matrix it becomes a mess, whether putting fields all into Rows (putting them into Columns just pushes everything out to the right). 

I tried to use "New Group" by the Sales person field, but could not figure out how to make that work. It seems like it would work but I created a New Group, put Ben in the group, then tried next Sales Person, etc. But then I am left with multiple Sales person columns.

I looked at GROUPBY DAX but does not appear it would work. 

Really appreciate at thoughts on how to achieve this, thank you in advance! 

[PijushRoy]

Can you please share sample table and expected result in excel format?

[sscanlon]

Hi, thank you, I was hoping that the final outcome would look like this, could be very basic but subtotals per Sales Person with 1 row separation with that subtotal. 

[amitchandak]

@sscanlon , You need to use matrix. In Matrix you have option Per Row Level (for Sub total), You can control what all levels you want a subtotal

[sscanlon]

OK thank you, but I cannot have it show like my image correct? as a standard table would show? 

If you know a way to accomplish that could you share it with me? 

I am trying to show all those columns in the same style as a standard table, but with subtotals by sales person.