# Total table **URL:** \ **Category:** Ask for Help\ **Created:** [January 20, 2024, 2:12pm UTC](https://community.glideapps.com/t/total-table/69781 "2024-01-20T14:12:03Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Sinisa\_Kovacicek](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sinisa_kovacicek/32/69591_2.png) [@Sinisa\_Kovacicek](https://community.glideapps.com/u/Sinisa_Kovacicek)\ **Post date:** [January 20, 2024, 2:12pm UTC](https://community.glideapps.com/t/total-table/69781/1 "2024-01-20T14:12:03Z")
I need help with the total table. ![2024-01-20](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/2/02c992497cea98a9fcefca076df5e4763c121390.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:** [January 20, 2024, 2:15pm UTC](https://community.glideapps.com/t/total-table/69781/2 "2024-01-20T14:15:27Z")
If you want a total per user, then you will need to create a Query column with a filter first, and then do a rollup through that. But, can you explain why you have 5 columns for fish instead of just 1? That looks like a big red flag to me, that will most likely cause you problems in the future. ---
**Author:** ![Sinisa\_Kovacicek](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sinisa_kovacicek/32/69591_2.png) [@Sinisa\_Kovacicek](https://community.glideapps.com/u/Sinisa_Kovacicek)\ **Post date:** [January 20, 2024, 2:36pm UTC](https://community.glideapps.com/t/total-table/69781/3 "2024-01-20T14:36:57Z")
> [@Darren\_Murphy](#): > > f you want a total per user, then you will need to create a Query column with a filter first, and then do a rollup through that. > > But, can you explain why you have 5 columns for fish instead of just 1? > That looks like a big red flag to me, that will most likely cause you problems in the future. Five columns due to five different types of fish ---
**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:** [January 20, 2024, 2:50pm UTC](https://community.glideapps.com/t/total-table/69781/4 "2024-01-20T14:50:25Z")
hmm, okay. I would do that differently, but let’s just work with what you have. Alright, so what you need to do is the following: - Create a Math column that adds the values in each of your 5 Fish columns. eg: `Fish1 + Fish2 + Fish3 + Fish4 + Fish5`. This will give you a total per row. - Create a multiple relation column that matches each persons name with itself. - Do a rollup-\>sum through the above relation. ---
**Author:** ![Sinisa\_Kovacicek](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sinisa_kovacicek/32/69591_2.png) [@Sinisa\_Kovacicek](https://community.glideapps.com/u/Sinisa_Kovacicek)\ **Post date:** [January 20, 2024, 2:56pm UTC](https://community.glideapps.com/t/total-table/69781/5 "2024-01-20T14:56:17Z")
If I get stuck, I’ll ask for help. Otherwise, the best thing would be if you could put it together for me. 😀 ---
**Author:** ![Sinisa\_Kovacicek](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sinisa_kovacicek/32/69591_2.png) [@Sinisa\_Kovacicek](https://community.glideapps.com/u/Sinisa_Kovacicek)\ **Post date:** [January 20, 2024, 3:19pm UTC](https://community.glideapps.com/t/total-table/69781/7 "2024-01-20T15:19:27Z")
![2024-01-20 (1)](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/9/69943849c0f64bec121e7b6278a2fb3253f2550d.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:** [January 20, 2024, 3:21pm UTC](https://community.glideapps.com/t/total-table/69781/8 "2024-01-20T15:21:23Z")
Okay. Are you just showing me that it works, or did you have another question? ---
**Author:** ![Sinisa\_Kovacicek](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sinisa_kovacicek/32/69591_2.png) [@Sinisa\_Kovacicek](https://community.glideapps.com/u/Sinisa_Kovacicek)\ **Post date:** [January 20, 2024, 3:27pm UTC](https://community.glideapps.com/t/total-table/69781/9 "2024-01-20T15:27:14Z")
I’m showing it works, but I’ll try another way.