Forum Discussion

HenryJS's avatar
HenryJS
Post Prodigy
6 years ago

Matrix: Customer Subtotals

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

Need Help

4 Replies

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    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's avatar
      HenryJS
      Post Prodigy
      6 years ago

      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

       

       

      • parry2k's avatar
        parry2k
        Super User
        6 years ago

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