Creating a new Group Column based on a condition

[madhurinani]

Hello,

I am stuck in 2 conditions that I need to create as part of my workflow.

Below is my input file screenshot.

Now I need to create a Tag/Group column that would group the rows based on number of rows above _total value in colunm Name

Eg.

The rows that are above the _total value should be grouped as A then the next set of rows should be grouped together until they reach the previous _total value.

I tried using the Multi-row formula but it didnt work out.

Name	Number	count
test	5	1
rain	6	1
ESOP	7	2
_total	18	4
rain	1	5
zoom	2	6
ESOP	3	7
_total	6	8

Any help would be appreciated

Thanks!

[messi007 · Accepted solution]

@madhurinani,

Please see below :

Attached the workflow,

Regards,

[madhurinani]

@messi007 : That worked like a charm. Thank you so much for your prompt response of my problem.

[ArtApa]

Hi @madhurinani - Hope this will help:

[messi007]

@madhurinani,

Happy to help :)

Regards,