Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Show Row Subtotal for Only One Row in Matrix

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   An...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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's avatar
jdbuchanan71
Super User
2 years ago

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's avatar
Anonymous
Not applicable
2 years ago

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".