Free Trial

Alteryx Designer Desktop Discussions

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

If there is just one row output, don't display totals

HBarge
8 - Asteroid

Hi,

This output is from a tree app where the user selects the school then the  Scholastic Year and then the Homeroom to get the attached output.

I however need a condition that if there is just one row output, it should not display the total row in the bottom and should display if there is more than one row.

 

Thanks,

Harshad

2 REPLIES 2
jasperlch
12 - Quasar

Hi @HBarge,

 

This could be achieved by using a combination of Count, Append and Filter tools:

 

Capture1.PNG

HBarge
8 - Asteroid

@jasperlch

the method works flawlessly. Thanks. however, there was one modification, The filter was set to [count]=1 which was changed to [count]=2

Thanks a ton!

Labels
Top Solution Authors