I need to remove certain data from a spreadsheet to generate my report, when I do a custom filter it will only seem to work when i do the AND OR options but I need data to be included for multiple columns for example I Do Internal category >= Transaction AND Internal Details= Self-Directed but since there are no rows that match that it returns a zero I need to capture that scenario,
Solved! Go to Solution.
@Mgstoly I've attached the workflow. Is this what you are looking for? I am looking at the dataset and some Self Directed records are related to a different Internal Category column (other than Transactions / Calculations). Is it okay if thats inside the dataset?
this one works too, Lots of options to get results with Alteryx 🙂