I have a customer list that includes open balances, however, I only want to select those accounts that have > 60 days balances. I would expect the output here to be customer A4, A6 & A7.
Clearly I am quite new with Alteryx and it seems that there should be a simple solution or even something a simple tool could manage, but again....I am very "green" to the tools
Any suggestions would be wonderful!
Customer | amount | age category |
A1 | 1,000 | > 60 days |
A1 | 100 | > 60 days |
A1 | 10 | < 60 days |
A1 | 1,000 | >60 days |
A2 | 100 | > 60 days |
A2 | 10 | <60 days |
A4 | 10,000 | > 60 days |
A5 | 10,000 | <60 days |
A6 | 1,000,000 | > 60 days |
A7 | 100 | > 60 days |
Use the Filter tool and use this formula: [age category] = "> 60 days"
Also check you table to provided, your results are not possible because there several more that are > than 60 days. You need more criteria to get just those results.
Thank you. However, the latter is what I'm trying to avoid. I have customers who have both > & < 60 day balances. However only want those customers with > 60 day balances only.
Based off what you are asking, there are more than just three results. Is there something I am not seeing here?
Please feel free to add more details it is hard to help if you are vague.
User | Count |
---|---|
60 | |
24 | |
24 | |
21 | |
21 |