Matrix with 2 or 3 tier levels

[Graham_Inners]

hello

I am trying to recreate this report currently in a spreadsheet:

the first row is just an account with a total. the 2nd row is a subtotal or rows 3 & 4. then SGA Other has another subtotal SGA Fringe Benefits Total and this has accounts below. So sometimes I have 2 tiers and sometimes 3

I have created 3 tiers tables and got it working in a Matrix :

what I would like is to hide the highlighted 'blank' tier 3 subtotals as these add no benefit to the report

thanks for any assistance

here is my pbix : https://drive.google.com/file/d/1dV2CnRBLlnXOkgMWmuMLHRvEhcSlfrN9/view?usp=share_link

regards

graham

[v-yangliu-msft · Accepted solution]

Hi  @Graham_Inners ,

Here are the steps you can follow：

1. Format visual.

Row subtotals

Per row level set on

Row level – Account Desc

Row – Show subtotal set off

2. Result:

Best Regards,

Liu Yang

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