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

Alteryx designer Discussions

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

Sort fields in Summarized data

Meteor

Hi, I would like to re-order the fields in the Cancel column so that it goes from 1, 2, ....to 10, 11a, 11b, 12a, 12b, 12c.  Currently the default order is such:

CancelCount
 3923
1137
1044
11a18
11b302
12a3
12b436
12c16
2107
32
4245
5228
61
7160
8750

 

Additionally, I would like to:

1. mark "Blank" for the blank fields. 

2. include a grand total at the bottom of the table

 

Thank you in advance!

Quasar
Quasar

Hi, to do so, I would advise you to use a 2 formulas on the field cancel:

first : if isempty([cancel]) then 'blank'

else [cancel] endif

 

and then on the field cancel too

padleft([cancel], 2, '0')

 

after that, you should be able to sort the way you want :)

 

Hope it helped!

 

 

Meteor

Hi, do I link the Formula tool after the Summarize tool?  I keep getting error on "The field "" is not contained in the record

 

 

Quasar
Quasar

@BJSOON I did a sample workflow for you based on the table you gave in the first post, it does the job ;)

Alteryx Partner

See Solution below,

 

you may need to add the "Add Totals" Macro

 

Spoiler

Spoiler
Atom

last row contains grand total

Labels