# How to add a Stacker rollup field

**URL:** <https://community.stackerhq.com/t/how-to-add-a-stacker-rollup-field/159>\
**Category:** Tips and Tricks\
**Created:** [July 22, 2021, 6:11pm UTC](https://community.stackerhq.com/t/how-to-add-a-stacker-rollup-field/159 "2021-07-22T18:11:02Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Chelsea\_Scriven](https://dub1.discourse-cdn.com/flex017/user_avatar/community.stackerhq.com/chelsea_scriven/32/156_2.png) [@Chelsea\_Scriven](https://community.stackerhq.com/u/Chelsea_Scriven)\
**Post date:** [July 22, 2021, 6:11pm UTC](https://community.stackerhq.com/t/how-to-add-a-stacker-rollup-field/159/1 "2021-07-22T18:11:02Z")

</div>

**Stacker Rollup Fields**

Stacker rollup fields can be used to summarize related values.

For example, in my Grant Tracker app, I have a table called ‘Foundations’. Each Foundation record contains a list of associated applications (linked to the ‘Applications’ table).

 ![Screen Shot 2021-07-22 at 10.54.06 AM](https://europe1.discourse-cdn.com/flex017/uploads/stacker/original/1X/7bd42d0c3dbd805f8d9cc2cccea22edfc42901e1.jpeg)

But what if I want to show the number of applications each foundation has? I could do so by using a roll up field. To do this, go to your field settings for the table and click “+ add field” \> rollup.

 ![Screen Shot 2021-07-22 at 11.00.38 AM](https://europe1.discourse-cdn.com/flex017/uploads/stacker/original/1X/956c35d1fa0f8fdd6d67f7d5b04d0a932fd6d620.jpeg)

Then, specify what you would like your field to be called, where you’d like the related values to come from (select from a linked table), and how you would like to summarize the data (i.e. sum, count of records, average, etc)

![Screen Shot 2021-07-22 at 11.05.21 AM](https://europe1.discourse-cdn.com/flex017/uploads/stacker/original/1X/ca25b5cb3fb9df69f916e07a58e2bbbf214b480c.png)  
Note - In order for a table to appear in the dropdown options for the roll up, there must be a link to that table.

Save and enabled the new field in your layout.

 ![Screen Shot 2021-07-22 at 11.07.23 AM](https://europe1.discourse-cdn.com/flex017/uploads/stacker/original/1X/bfdd5826b42ca1f840691900d4ac17294a98644b.png)
