Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Reporting - Table tool

Hema_sundar
6 - Meteoroid

Hi ,

 

I would like to highlight The weekly sales if "Is Holiday " is True. Kindly suggest how to create a rule for this in Table tool. 

 

Hema_sundar_0-1686366920770.png

 

2 REPLIES 2
Yoshiro_Fujimori
15 - Aurora

Hi @Hema_sundar ,

 

You can do it by configuring the "Column Rules" for [Weekly Sales].

 

Table tool configuration

Yoshiro_Fujimori_0-1686388157134.png

 

Column Rules Edit window

Yoshiro_Fujimori_1-1686388218417.png

If [IsHoliday] column is Bool type, you can simply use it in Formula.

 

Output

Yoshiro_Fujimori_2-1686388392922.png

I hope I answered to your question.

 

Hema_sundar
6 - Meteoroid

Hi @Yoshiro_Fujimori,

 

Thank you very much for the quick solution. it works for my data set many thanks

Labels