Forum Discussion

sampathK's avatar
sampathK
Microsoft Employee
6 years ago
Solved

Change Matrix Column Sub Total Position from Last to First.

Hello Team,

             I have one matrix with some and included Row Sub Total and Column Sub Total. Due large amount in column categorizations end uses every time scrolling left to right for analysis some times this get irritation to them. I want to change column Sub Total right to left second most column in matrix.  Is it poosible to change or any alternative case we have ??

 

Thanks in advance.

 

Regards,

THEASK.

Need Help
  • v-yingjl's avatar
    v-yingjl
    6 years ago

    Hi sampathK ,

     

    In Matrix visual format, you can change the Row subtotal position with Top or Bottom in Subtotals menu but you cannot change the Column subtotal position.

     

    Best Regards,

    Yingjie Li

     

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

2 Replies

  • v-yingjl's avatar
    v-yingjl
    Community Support
    6 years ago

    Hi sampathK ,

     

    In Matrix visual format, you can change the Row subtotal position with Top or Bottom in Subtotals menu but you cannot change the Column subtotal position.

     

    Best Regards,

    Yingjie Li

     

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

  • Mariusz's avatar
    Mariusz
    Community Champion
    6 years ago

    Hi sampathK 

     

    As v-yingjl  mentioned you can not change the subtotal column position, but if you are concerned by users scrolling left/right you can always move Values from columns to rows as per below.

     

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn