Iterative Macro Assistance

Andrew

Hello,

I have a sales routine that needs to be processed for each sales category, with the output being written to a worksheet tab in the Excel workbook. The tab needs to be named with the category name.

I've set up the flow, with a filter on category.  I'd like to eliminate the filter and have the process run for each category.  There may be more categories in subsequent periods so the iteration is not a fixed number.  

I watched the tutorials and read other forums, but I can't seem to accomplish the task.

I've attached the workflow.  A macro solution would be much appreciated.

Thank you,

Andrew

Office Sales Report.yxzp

AngelosPachis

Hi @Andrew ,

As you want to run your workflow for each product category, a batch macro might be an easier way to do that compared to an iterative macro. Your batch macro will run your workflow for each record that feeds into the reversed questionmark

As you can see above, I've used a summarize tool to group on the field category, so now my batch macro will run for each one of those three values. Those values will be fed to a control parameter, which is that funny looking tool that look like a cog. That will dynamically update your filter each time this workflow runs.

So first time it will run for furniture, then for office supplies and finally for technology and all results will be stacked together

Hope that helps

Office Sales Report.yxzp