Enter rows after certain fields

[Emanuelis]

Hi all, I have the following data set: Name Quantity Apples 1 Oranges 2 Kiwis 3 Bananas 4 Potatoes 5 Tomatoes 6 Chicken 7 I want to insert new rows only after Bananas and Tomatoes, label them as total fruits and total vegetables and then makes those rows to summarise the relevant data Name Quantity Apples 1 Oranges 2 Kiwis 3 Bananas 4 Total fruits 10 Potatoes 5 Tomatoes 6 Total vegetables 11 Chicken 7 Any clever ones out there that can help?

[JoeS]

Hi @Emanuelis 

I have created a group lookup up and then used that to create the totals. I had to prefix the "Total" with "Zzzzz" to make sure it always come last.

[danilang · Accepted solution]

Hi @Emanuelis 

Here's a slightly different way, similar to the solution by @JoeS but it retains your original row ordering

The trick is to use a record id and then set the record Id of the total row to be .5 more than the last item in the group

 

Dan

[JoeS]

@danilang nice addition!

Going to re-use that now going forwards.