Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

subtotals field format - aligning

Hi, Apologies if this a bit simple, I always try to find answers on PB forum before posting but I have not been able to find an answer to this one. 

 

I am trying to alighn my subtotals to the centre. Under the field formating I can alighn all my fields but not subtotals field. The resulting matrix table looks horrible and was wondering if any one has come across this issue and resolved it. thanks 

 

  • Hi Anonymous

    Look at the picture, the penult is “Apply to subtotal”, the last one is “Apply to total”.

     

    Best Regards

    Maggie

  • Anonymous's avatar
    Anonymous
    8 years ago

    Thanks Magie, that was great. :)

5 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support

    Hi Anonymous

    Look at the picture, the penult is “Apply to subtotal”, the last one is “Apply to total”.

     

    Best Regards

    Maggie

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks Magie, that was great. :)

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi,

       

      I'm a newbie and having the same issue but I can't seem to find the "field formatting" drop down for Matrix style tables. Any help appreciated.

       

      JD

      • jamespatterson's avatar
        jamespatterson
        Frequent Visitor

        Hey, have a look here, click on "Apply to Total" on the "Specific Column"

         

    • Anonymous's avatar
      Anonymous
      Not applicable

      v-juanli-msft , When I set the Alignment to Right, and select Apply to Values, and Apply to Header, and Apply to Subtotals, and Apply to Total I find that the column header of the column subtotal is aligned left.

      How do I get the column header of the column subtotal to align right?