Show Row Subtotal for Only One Row in Matrix

[Anonymous]

I have this data:

Item Number	Site	Warehouse	Location	Inventory Physical
1	A	ABC	11	10
1	A	DFG	12	50
1	A	PTN	15	100
1	B	FF	22	150
1	B	GG	25	200

And I am trying to figure out how I can have a matrix with the rows in the following order: Item Number > Site > Warehouse > Location, and then Inventory Physical in the values with stepped layout off. 

Where it gets tricky is I only want to see the sum of inventory physical for the item number level, I don't want to see totals for site, warehouse, or location. I have went through all of the matrix settings and can't figure out how to achieve this.

[v-kongfanf-msft · Accepted solution]

Hi @Anonymous ,

You can try below formula and turn off stepped layout icon.

TotalInventoryPhysical = 
SUM('Table'[Inventory Physical])

DisplayInventoryPhysical = 
IF(
    ISINSCOPE('Table'[Item Number]),
    [TotalInventoryPhysical],
    BLANK()
)

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jdbuchanan71]

In the matrix settings, under Row subtotals, you can switch on 'Per row level' and that will let you select which levels get a sub total.

You would select the rows you want to disable it on in the 'Row level' dropdown then turn off 'Show Subtotal'

[Anonymous]

When I turn off subtotal for all rows except item number, it doesn't work correctly, it is still somehow managing to sum by the last row, "Location".