Alteryx Designer Desktop Discussions

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

Row Rule Formatting

heelsfan99
5 - Atom

Hello,

 

Long time lurker, first time poster here. Preface this with many thanks for resolution as I am sure this is something basic that I am overlooking.

 

I have a table, where I have subtotal and total rows on fields ‘Division’ & ‘Region’. For both region and overall totals, the rows are highlighted, however I cannot correctly apply a row rule to highlight the overall total separately. 

Current Table Output:

 

heelsfan99_0-1671551272155.png

 

Desired output (where overall total row highlighted yellow)

heelsfan99_1-1671551333099.png

 

Currently have 2 row rules:

1. IsNull([Region]) (highlight grey)

heelsfan99_2-1671551416216.png

 

2. Rule 2, contains([Division],"Total") highlight yellow

 

heelsfan99_3-1671551479917.png

 

Regardless of rule order, all rows where region is null is highlighted in grey (i.e. rule 1). Essentially, I guess the rule should be if Region is null and division <> Total, then we would like to color grey, otherwise yellow. Again, I am sure this is something simple that I am overlooking. Thanks again!

 

 

 

 

3 REPLIES 3
DavidSkaife
14 - Magnetar

Hey @heelsfan99 

 

Try ticking 'This rule shold override...' on the second rule:

 

DavidSkaife_0-1671552250601.png

DavidSkaife_1-1671552281231.png

 

 

binuacs
21 - Polaris

@heelsfan99 One way of doing this

binuacs_0-1671552321454.png

 

heelsfan99
5 - Atom

@DavidSkaife

 

I was certain I had performed this, but apparently I had not. Wow, the obvious directly in front of me. 

 

Many thanks and marked your solution as accepted! 

 
Labels
Top Solution Authors