Forum Discussion
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 |
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.
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 KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
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'
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 KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
