# Roll up of relation column **URL:** \ **Category:** Ask for Help\ **Created:** [April 21, 2023, 6:54pm UTC](https://community.glideapps.com/t/roll-up-of-relation-column/60812 "2023-04-21T18:54:02Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![George\_Pillari](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_pillari/32/55971_2.png) [@George\_Pillari](https://community.glideapps.com/u/George_Pillari)\ **Post date:** [April 21, 2023, 6:54pm UTC](https://community.glideapps.com/t/roll-up-of-relation-column/60812/1 "2023-04-21T18:54:02Z")
I have a table of books that includes the book title and the user who has read the book. Many users read the same books. I am trying get a total of books read by title. I set up a second table that has the book title and a second column that is a relation from the title to the big table of all books read. The relation table allows multiples and correctly lists each user that has read the book. I can look at the table and count the number of users in the relation column for each book. When I add a rollup column to count the number of items in the relation column, the relation column does not show up as a choice to rollup. I have read through all of the forum entries and Glide documentation on this and cannot crack it. Any help would be appreciated. ---
**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:** [April 21, 2023, 6:56pm UTC](https://community.glideapps.com/t/roll-up-of-relation-column/60812/2 "2023-04-21T18:56:11Z")
Can you show a screen shot of your relation configuration? ---
**Author:** ![George\_Pillari](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_pillari/32/55971_2.png) [@George\_Pillari](https://community.glideapps.com/u/George_Pillari)\ **Post date:** [April 22, 2023, 10:07am UTC](https://community.glideapps.com/t/roll-up-of-relation-column/60812/3 "2023-04-22T10:07:14Z")
a ![Screen Shot 2023-04-22 at 3.03.52 AM (2)](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/f/5f202afeff559c4c30725231ffcc92dafe4cafa3.jpeg) ![Screen Shot 2023-04-22 at 3.06.03 AM (2)](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/c/ecb7addeeb21d321876f293e42a29baf7f2b47ea.jpeg) Two screen shots: The rollup table and the detail table. Thank you ---
**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:** [April 22, 2023, 10:14am UTC](https://community.glideapps.com/t/roll-up-of-relation-column/60812/4 "2023-04-22T10:14:31Z")
Your relation column looks okay. So when you add a Rollup column to your “rollups” table, you are saying that the “relate” column doesn’t appear as an option for “Summarise the values of”? That doesn’t sound right to me. Can you try adding the column, and then show me what you see when you expand that drop-down (like below): ![CleanShot 2023-04-22 at 18.12.03@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/5/0519ea1f3840f93190dd60642ed9be5d7f95f142.png) ---
**Author:** ![George\_Pillari](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_pillari/32/55971_2.png) [@George\_Pillari](https://community.glideapps.com/u/George_Pillari)\ **Post date:** [April 22, 2023, 10:34am UTC](https://community.glideapps.com/t/roll-up-of-relation-column/60812/5 "2023-04-22T10:34:04Z")
![Screen Shot 2023-04-22 at 3.33.23 AM (2)](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/b/6b26e50031a613c3ac545d6cd0eaf3244d83c451.jpeg) ---
**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:** [April 22, 2023, 10:37am UTC](https://community.glideapps.com/t/roll-up-of-relation-column/60812/6 "2023-04-22T10:37:04Z")
It’s the first item in the list - “relate” ---
**Author:** ![George\_Pillari](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_pillari/32/55971_2.png) [@George\_Pillari](https://community.glideapps.com/u/George_Pillari)\ **Post date:** [April 22, 2023, 10:37am UTC](https://community.glideapps.com/t/roll-up-of-relation-column/60812/7 "2023-04-22T10:37:54Z")
Sorry for the bother. Thank you! ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [April 26, 2023, 6:16pm UTC](https://community.glideapps.com/t/roll-up-of-relation-column/60812/8 "2023-04-26T18:16:31Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.