I have a file that contains data with product, percentage, and number of products.
I want to transfer this data into another file, grouping it by product.
Then, I want to compare the percentages:
-
if the percentage is greater than 50%,
-
or if it is less than or equal to 50%,
in order to know, for each product, how many items fall into each category (above 50% or below 50%).
I’m having trouble figuring out how to retrieve the data and compile it into another file, based on whether each product is greater than or less than 50%.
Hey Valentin,
can you show some screenshots of the scenario you have so far? Where is the data coming from and in what format? Where is it going to?
Let me show you an exemple :
Here is a list of possible orders :
I would like to take this information and compile it into this table.
Here’s what i have for now :
I’m fairly certain this can be done with VLOOKUP inside the sheet without having to involve Make.
But for argument sake - you can have an aggregator after the Search module and then set the aggregator to group them by Product. This will give you a separate array for each different product, then you can use an iterator followed by a numeric aggregator allowing you to process the different values.
Thank you for your response, i have another problem.
The answer I have thanks to my scenario is one square below the desired one, do you know why and how to arrange that?
