Removing all data below a value in a column if it's equal to the first

Question

Hi,

I am working on creating a summary for a report and one of the tables is showing the user the options they selected from a tree hierarchy. I would like to have it work like the attached image. That way if they selected one division it doesn't show it for every row if they are all the same. I appreciate the help!

Alteryx Help.PNG

philipmannering · Accepted Answer

Hi @mullinsjo

See one potential solution below,

Thx

Phil

AngelosPachis · Accepted Answer

Hi @mullinsjo ,

I would suggest using a multi-row formula to assign an ID for each Group-Division combination. Then, with a multi-field formula, for the fields of your selection (in this case Group and Division) you can replace the record with a RecordID>1 with Null.

EDIT : Not fast enough, @PhilipMannering solution would also work

Cheers,

Angelos