# How to create a new row that shows sum of multiple rows

**URL:** <https://community.parabola.io/t/how-to-create-a-new-row-that-shows-sum-of-multiple-rows/844>\
**Category:** Ask a question\
**Created:** [July 21, 2020, 9:15pm UTC](https://community.parabola.io/t/how-to-create-a-new-row-that-shows-sum-of-multiple-rows/844 "2020-07-21T21:15:33Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Akiko](https://avatars.discourse-cdn.com/v4/letter/a/ce73a5/32.png) [@Akiko](https://community.parabola.io/u/Akiko)\
**Post date:** [July 21, 2020, 9:15pm UTC](https://community.parabola.io/t/how-to-create-a-new-row-that-shows-sum-of-multiple-rows/844/1 "2020-07-21T21:15:33Z")

</div>

Hi,  
I’d like to know how to get a sum of multiple rows.

 ![スクリーンショット 2020-07-20 17.46.14](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/1X/4545f78bbd0af326f6df2d4eedc2ac2654cd7f53.png)

For example, how can I add Item A and B price, which is 390+1980, in a one row?

Thanks.

---

<div class="post-metadata">

**Author:** ![sachi](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/sachi/32/10_2.png) [@sachi](https://community.parabola.io/u/sachi)\
**Post date:** [July 21, 2020, 10:57pm UTC](https://community.parabola.io/t/how-to-create-a-new-row-that-shows-sum-of-multiple-rows/844/2 "2020-07-21T22:57:24Z")

</div>

Hey @Akiko! I think I might need more information on what you’re ultimately trying to do to provide a more scalable solution.

To accomplish what you mentioned, I would use a Remove rows step to filter for rows where Line Items: Title is A or B.

 ![Screen Shot 2020-07-21 at 3.52.31 PM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/1X/d4531dfe64d388b15dcd1153f2ed67aee43b5826.png)

And then, I would use the Sum values step to calculate the sum:

 ![Screen Shot 2020-07-21 at 3.54.07 PM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/1X/694cf3db863a93c33a126954902345ec7c89bfcf.png)

If there’s a shared identifier that we can use, we could select that column under the option to `Create a row for each unique value`. For example, if you were trying to sum the price based on a shared Order ID, that would be easy to accomplish in this way.

As you can see, my proposed solution to you is pretty manual and I’m not sure it helps solve your actual problem. If you can tell me more about what you’re trying to do, I can offer alternate solutions!

---

<div class="post-metadata">

**Author:** ![Akiko](https://avatars.discourse-cdn.com/v4/letter/a/ce73a5/32.png) [@Akiko](https://community.parabola.io/u/Akiko)\
**Post date:** [July 29, 2020, 2:50pm UTC](https://community.parabola.io/t/how-to-create-a-new-row-that-shows-sum-of-multiple-rows/844/3 "2020-07-29T14:50:38Z")

</div>

Hi @sachi, thanks for the solution! I couldn’t find “Row Filter” but I used “Remove Duplicate Row” and combined A&B based on a shared Order ID.

---

<div class="post-metadata">

**Author:** ![sachi](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/sachi/32/10_2.png) [@sachi](https://community.parabola.io/u/sachi)\
**Post date:** [July 29, 2020, 4:00pm UTC](https://community.parabola.io/t/how-to-create-a-new-row-that-shows-sum-of-multiple-rows/844/4 "2020-07-29T16:00:01Z")

</div>

Great! Glad to hear that worked. Ah yes, we just renamed our steps to clear up some user confusion about what the various steps do. The Row Filter step is now called “Remove rows”, but if “Remove duplicate rows” worked for your flow, no need to change it!