Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Filter to most recent budget version

jdbustamantec
6 - Meteoroid

Hi

 

I have a table with budget versions by line item data for multiple projects

 

example project

jdbustamantec_0-1651781014288.png

 

Each category code name item have a budget revision number (example of a category code name item below)

jdbustamantec_1-1651781109398.png

I need a formula to filter old budget revision numbers except the last one (in the example it would be budget revision 3).

 

The last budget revision number will be different for each project in the table so I need to make sure the formula is always picking up the latest record instead of a fixed number. Any ideas?

 

Thanks

 

 

 

1 REPLY 1
MeganBowers
Alteryx Community Team
Alteryx Community Team

Hi @jdbustamantec ,

 

You could use a sort tool and sort on Category Code Name ascending, and then Budget Version Number descending. Then, use a sample tool to select the first row, selecting the group by column to be the Category Code Name. This way, it will pull the first record for each Category Code Name, which will be the record with the highest budget revision number (due to the sorting done before hand).

Labels