Dynamic data filtering

[aishwarya_baburaj98]

Hi All,

If below is an example of my input data for the current month.  I want to filter the records by 4 different categories, for further data manipulation. 

Categories	INVOICE NO
A	11111111
A	31111111
B	11111114
B	11111155
C	11111669
D	45111111

But, the next month, I may only have 3 categories. 

Categories	INVOICE NO
A	11115587
A	31441111
C	11681114
D	93301155
D	12311669
D	45111151

Some months, there maybe a new category added I may not be aware of. Is there any way to accomplish this? All my inputs and the desired output is excel format.

[atcodedog05]

Hi @aishwarya_baburaj98 

You can do something like this. Have a category list and compare with it to filter only those categories. Here is how you can do it.

Workflow:

Hope this helps : )