Forum Discussion
Subtotals without Matrix using Standard Table
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!
4 Replies
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
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.
Can you please share sample table and expected result in excel format?
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.
