# How do I show aggregated value instead of multiple entries?

**URL:** <https://community.glideapps.com/t/how-do-i-show-aggregated-value-instead-of-multiple-entries/43307>\
**Category:** Ask for Help\
**Created:** [June 21, 2022, 1:24am UTC](https://community.glideapps.com/t/how-do-i-show-aggregated-value-instead-of-multiple-entries/43307 "2022-06-21T01:24:40Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![remoteworker.id](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/remoteworker.id/32/36396_2.png) [@remoteworker.id](https://community.glideapps.com/u/remoteworker.id)\
**Post date:** [June 21, 2022, 1:24am UTC](https://community.glideapps.com/t/how-do-i-show-aggregated-value-instead-of-multiple-entries/43307/1 "2022-06-21T01:24:41Z")

</div>

Have a look at inline list below:

 ![Screen Shot 2022-06-21 at 08.18.49](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/1/51643fca50b43ec958584a42d3b59dd8b0d6d895.jpeg)

You can see that ben\*.\* are being displayed twice. This is because in the underlying sheet ben\*.\* did shown twice: below is the picture. ben\*.\* is data with id 3oibJ…

 ![Screen Shot 2022-06-21 at 08.21.53](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/1/e126cadf4ddc21542c1923d72cdd5c1783fbe310.png)

This sheet is composite of:

- User Row ID. Ben Row ID is 3oibJ…
- Syirkah Row ID. Obviously the syirkah/startup is 5YsIL…

Now, ofcourse I would like to show that Ben\*.\* as one liner data, but with accumulated value of Rp 20,000,000 (this is because he input Rp 10,000,000 twice)

How do I solved this? I do hope I don’t have to create another sheet for this solution

Thanks!

---

<div class="post-metadata">

**Author:** ![resepsionis\_ganteng](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/resepsionis_ganteng/32/39081_2.png) [@resepsionis\_ganteng](https://community.glideapps.com/u/resepsionis_ganteng)\
**Post date:** [June 21, 2022, 4:30am UTC](https://community.glideapps.com/t/how-do-i-show-aggregated-value-instead-of-multiple-entries/43307/2 "2022-06-21T04:30:24Z")

</div>

To make adding them easier, it’s better to create another worksheet. with a list of investors’ names and a worksheet of investors’ investment history/incoming investment history.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [June 21, 2022, 5:02am UTC](https://community.glideapps.com/t/how-do-i-show-aggregated-value-instead-of-multiple-entries/43307/3 "2022-06-21T05:02:52Z")

</div>

It seems that your question is similar to [this](https://community.glideapps.com/t/creating-pos-system-with-glideapps/43253) one.

You’ll see that I provided a solution in that thread. It’s not a simple solution, but it does avoid creating an extra table.

---

<div class="post-metadata">

**Author:** ![remoteworker.id](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/remoteworker.id/32/36396_2.png) [@remoteworker.id](https://community.glideapps.com/u/remoteworker.id)\
**Post date:** [June 21, 2022, 5:18am UTC](https://community.glideapps.com/t/how-do-i-show-aggregated-value-instead-of-multiple-entries/43307/4 "2022-06-21T05:18:21Z")

</div>

Woa! Rollup and … else!

On it!  
I’ll keep you posted!