Formatting Output Bolding Total Lines and Header

[CrystalC0203]

Hello Community,

I need some help with formatting. Right now my data is coming out fine but I would like bold certain text on the file.

On the attached i have my original output and what i would like to see.

This is my original data:

ARE	Month	Symbolic Account	Account Number	GL Total	Total Accrual	Total BiWeekly Amounts	UPD%	Accrual Calculation	Variance	% Differences
476T	06	T003			10	21.27	0.5	10.635	-0.635
476T	06	T002			13487	27316.44	0.5	13658.22	-171.22
476T	06	B001			174798	353891.26	0.5	176945.63	-2147.63
476T			47118000	-188295
476T Total				-188295	188295	381228.97		190614.485	-2319.485	0.01

I would like for it to look like this:

ARE	Month	Symbolic Account	Account Number	GL Total	Total Accrual	Total BiWeekly Amounts	UPD%	Accrual Calculation	Variance	% Differences
476T	06	T003			10	21.27	0.5	10.635	-0.635
476T	06	T002			13487	27316.44	0.5	13658.22	-171.22
476T	06	B001			174798	353891.26	0.5	176945.63	-2147.63
476T			47118000	-188295
476T Total				-188295	188295	381228.97		190614.485	-2319.485	0.01

[alexnajm]

Sounds like you'll want to use the Table tool as a part of the Reporting tool palette!

[alexnajm · Accepted solution]

Table Tool | Alteryx Help

Note the ability to affect the headers formatting under the Default Table Settings. For the Total row, you can create a Row Rule that can look for when Contains([ARE],'Total') and then formatting as bold accordingly.

[alexnajm]

Then you'd use the Render Tool to output!

[CrystalC0203]

Thank you @alexnajm  that worked!