Forum Discussion

smullan's avatar
smullan
Frequent Visitor
8 years ago

Remove Subtotal or Grand Total by Column

Hi,

 

Is it possible to remove subtotals or grand totals by column if I only want some of them visible in a matrix?

 

E.g. one subtotal sums a column of percentages to over 300% so I would like to remove this subtotal but keep the others. 

 

Kind regards,

 

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Check this Link might be useful

    • smullan's avatar
      smullan
      Frequent Visitor
      8 years ago

      Thank you for the link.

       

      This is useful however is there something similar for columns?

       

      Kind regards,

       

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi smullan,

     

    The subtotal option can turn on/off total values for all columns. It is not supported to disable some specific one.

     

    Regards,

    Yuliana Gu