Implementing a 'for loop'

Question

Hi,

I think that this is a great bit of software but sometimes takes a second or two to get your head around how to get to your solution in the easiest way hence this question.

If I have some data with a 'Country' field and I want output results including the overall values and then the specific country values for each country in the dataset, how is that best done?  I believe that I have looked at all the grouping options within the 'Reporting' tools and can not see how this can be done with the updated country level sub-totals. So is a macro the only way?

Thee "cheats" approach is just to hard code a flow for all the options but this seems to contrary to all good reasoning!

Thanks in advance,

Peter

mceleavey · Answer

Hi @PeterV121 ,

if you can provide some mock data and a breakdown of what you want then we can help.

M.

PeterV121 · Answer

Thanks for the input!

Peter

atcodedog05 · Answer

Hi @PeterV121

Take a look at the iterative macro it might helo in your case.

https://community.alteryx.com/t5/Interactive-Lessons/Creating-an-Iterative-Macro/ta-p/657925

Hope this helps : )