KPI Ranking with a Macro

[ArminL]

Hi Community!

My problem is the following: As you can see in the attached Macro Workflow I want to rank several KPI's into Percentiles.

Could you tell me if there is any way i can get something like a check box, where I can simply choose which KPI's I want to be ranked and the workflow does that for all of them (even if I have an Input with 7 Indicators or only 1 Indicator). 

Right now as you can see I am manually adding each Indicator with another action.

Is there a way to do it with an iterative macro? What do you think?

Thanks in advance and cheers

ArminL

[ArminL]

ps.: this is the dummy database I used for the macro :)

[BenMoss · Accepted solution]

Something like this should do the trick.

Ben

[ArminL]

Aaand something like this does the trick! Thank you very much, sir! :)