Enter rows after certain fields

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?

Best Practices

Accepted answers

danilang

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

totals.yxmd

All comments

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.

TotalRows.yxmd

danilang

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

totals.yxmd

JoeS

@danilang nice addition!

Going to re-use that now going forwards.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703