Matrix: Customer Subtotals

[HenryJS]

Hi all,

Is there a way of creating custom subtotals in the same line as the subsets below.

For example, a subtotal on the same row as 'London' and 'London Aviation' below.

When I turn on subtotals I get the below results and it creates too many rows and total in the subset field which is incorrect.

I would also like to organise Teams into a custom order, starting with London, North, Trades & Labour amd then Permanent.

Thanks,

Henry

[parry2k]

@HenryJS not sure what you mean by subtotal on same line for London and London Aviation, London is parent to Aviation? You can surely choose where you want subtotal, top or bottom and you can also turn on/off for which section you want subtotal. Not sure if that is what you are looking for?

[HenryJS]

Hi @parry2k ,

I want the subtotals to appear in the rows I have highlighted below and not top or bottom. As top and bottom subtotals creates too many rows for visualisation.

Thanks,

Henry

[v-yuta-msft]

@HenryJS ,

I'm afraid the built-in matrix visual doesn't have such kind of option. You may search custom matrix visuals in visual market.

Regards,

Jimmy Tao

[parry2k]

@HenryJS you can turn on and off subtotal per row level under format pane