community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

How to Cross tab the data after reporting Table in Alteryx

Asteroid

Hi Community,

 

How to cross tab the data after the report table in alteryx without loosing the conditional color formatting used in it.

 

Regards,

Prasad

Alteryx Certified Partner

I don't believe that's possible. Once a Report Table is created, it is saved in a single Layout-type field. The regular transformation tools will not work the same on that single field. The formatting must come after the transformation. 

Asteroid

Hi Charlie,

 

Thanks for your reply. Is there any way that we an make conditional formatting dynamic in the report table(i.e. if any extra column is added in the input, conditional format should be applied to that new column(condition is similar for all the columns, please see the below example) and if any column is removed in the input that should not throw any error.

 

Condition for Column1 :

X>=Y AND Col1>=Col1 Threshold----highlight in Green

Condition for Column2 :

X>=Y AND Col2>=Col2 Threshold---highlight in Green

.... and so on.

 

 

Regards,

Prasad

Labels