Different alignment in matrix table

[Saxon10]

Hi,

I have a following columns in data table Area, Result, Colour code, Status. I am applying conditional formatting based on the result column in data table.

I would like to know the result status based on the conditional formatting in matrix table and it’s working fine but it’s showing different alignment/ not same comparing to others in matrix table? Do you know why? and how can I make all of them same alignment?

AREA	RESULT	Colour Code	FILTER	Status
DD1	WIN	#73B761	D	STATUS
DD1	WIN	#73B761	D	STATUS
DD1	WIN	#73B761	D	STATUS
DD1	WIN	#73B761	D	STATUS
DD1	WIN	#73B761	D	STATUS
DD1	WIN	#73B761	D	STATUS
DD2	LOSS	#F17925	D	STATUS
DD3	LOSS	#F17925	D	STATUS
DD3	LOSS	#F17925	D	STATUS
DD3	LOSS	#F17925	D	STATUS
DD3	LOSS	#F17925	D	STATUS
DD4	LOSS	#F17925	D	STATUS
DD5	LOSS	#F17925	D	STATUS
DD6	LOSS	#F17925	D	STATUS
DD7	LOSS	#F17925	D	STATUS
DD8	LOSS	#F17925	D	STATUS
DD9	LOSS	#F17925	D	STATUS
ED1	NO RESULT	#95C8F0	E	STATUS
ED2	NO RESULT	#95C8F0	E	STATUS
ED3	NO RESULT	#95C8F0	E	STATUS
ED3	NO RESULT	#95C8F0	E	STATUS
ED3	NO RESULT	#95C8F0	E	STATUS
ED3	NO RESULT	#95C8F0	E	STATUS
ED4	NO RESULT	#95C8F0	E	STATUS
ED5	NO RESULT	#95C8F0	E	STATUS
ED6	NO RESULT	#95C8F0	E	STATUS
ED7	NO RESULT	#95C8F0	E	STATUS
ED8	NO RESULT	#95C8F0	E	STATUS
ED9	NO RESULT	#95C8F0	E	STATUS
BD1	TIE	#9A64A0	B	STATUS
BD2	TIE	#9A64A0	B	STATUS
BD3	TIE	#9A64A0	B	STATUS
BD3	TIE	#9A64A0	B	STATUS
BD3	TIE	#9A64A0	B	STATUS
BD3	TIE	#9A64A0	B	STATUS
BD4	TIE	#9A64A0	B	STATUS
BD5	TIE	#9A64A0	B	STATUS
BD6	TIE	#9A64A0	B	STATUS
BD7	TIE	#9A64A0	B	STATUS
BD8	TIE	#9A64A0	B	STATUS
BD9	TIE	#9A64A0	B	STATUS

Note: The area code length is 3 characters.

Any advise idea please?

[MFelix · Accepted solution]

Hi @Saxon10 ,

That is related with the font type and the fact that is Monospaced or not, that returns different spaces depending the letter.

If you change it to Arial or courier new for example the columns stay similar.

[Saxon10]

Hi MFelix,

Thanks for your time to investigate my query and sorry for the late respones.

after apply the conditional formatting in matrix table then alignment completely changed but it won't changed in table level. Please refer the snaphot

[Anonymous]

HI @Saxon10,

Did you mean the total level layouts? If that is the case, you can't do custom with them. Conditional formatting can be applied to the row content, they cant be used on the header or total level.
Regards,
Xiaoxin Sheng

[Saxon10]

Hi.

Thanks for your advice.