Create a Filter Macro or Split Report Macro

[katonyaj]

I'm trying to create a filter macro for a report that we use for over 50 locations and over 5k lines that would allow me to filter by entering the name or from a dropdown. Or even if possible, would split the file into separate files based on the filtered name. 

This is as far as I got and now I'm stuck

I have attached a sample report and my attempt at this macro. 

Any advice would be great!

[jarrod · Accepted solution]

splitting the file is pretty straight forward:

at the bottom of the config window, there is an option to split the output file from a field.

if you need to filter the macro and run for all locations, i would choose a batch macro to accomplish that task, but you could possibly do it by using groups within the flow itself. From the screenshot below, you look like you want to run single reports, is that correct?

[katonyaj]

Yes correct we want to run single reports from the files. I will also give the split option a try.