subtotals field format - aligning

[Anonymous]

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 

[v-juanli-msft · Accepted solution]

Hi @Anonymous

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

Best Regards

Maggie

[v-juanli-msft · Accepted solution]

Hi @Anonymous

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

Best Regards

Maggie

[Anonymous]

@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?

[Anonymous]

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]

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

[Anonymous · Accepted solution]

Thanks Magie, that was great. 🙂