Table Tool - Crosstab/Pivot Formatting

jhueschen

Hi all,

I have been attempting to utilize conditional row/column/data formatting available in the Table tool, however it does not appear to be available when using the Pivot option.

Does anyone know another way to do this or a way around the restriction?  I've attached an Excel based example; basically how I would like it to look (value < x make cell orange, value > x make cell yellow, etc)

I have tried using a Basic table, but the dynamic nature of the columns causes issues and Alteryx throws errors when attempting to format 'Dynamic/Unknown' columns.

Example.xlsx

JoeM

@jhueschen

I'm not sure of the starting state that you data is in. If I had that insight, I might be a little better at guiding you to your desired result. None-the-less, I have taken the small liberty of assuming you want a total row at the bottom and conditional coloring for the column "Avg_Regular". Since coloration is not an option for pivoted data in the table tool, we have to make sure that everyhing is set up to our liking before entering into the table tool. Attached is my soltuion.

Could I also see how you are formatting you dynamic columns?

Thanks,

Joe

tableformat.yxmd