# Need User Specific Total of the column based on Login **URL:** \ **Category:** Ask for Help\ **Created:** [January 22, 2024, 9:11am UTC](https://community.glideapps.com/t/need-user-specific-total-of-the-column-based-on-login/69845 "2024-01-22T09:11:37Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [January 22, 2024, 9:11am UTC](https://community.glideapps.com/t/need-user-specific-total-of-the-column-based-on-login/69845/1 "2024-01-22T09:11:37Z")
Hi Guys, I have a table with a column with name “Invoice Value” Each Row in the table represents an invoice of a particular user. Table can consist or Multiple invoices for the same person Meaning the column can have multiple values for the same person. There is another column in the table which represents which Person this invoice is for. I have a text field in Glide which has to show the total of all the invoices for the particular logged in person. How do I do it? My datasource is Airtable ---
**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 22, 2024, 9:15am UTC](https://community.glideapps.com/t/need-user-specific-total-of-the-column-based-on-login/69845/2 "2024-01-22T09:15:28Z")
- Create a multiple relation column that matches the User identifier column with itself. - Create a rollup column, target it at the multiple relation column, and take a sum of the invoice value. ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [January 22, 2024, 9:23am UTC](https://community.glideapps.com/t/need-user-specific-total-of-the-column-based-on-login/69845/3 "2024-01-22T09:23:32Z")
Thank you for the reply @Darren_Murphy Pardon me but I am pretty new to Glide, Could you explain it in more detail? Thank you in Advance ---
**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 22, 2024, 9:28am UTC](https://community.glideapps.com/t/need-user-specific-total-of-the-column-based-on-login/69845/4 "2024-01-22T09:28:22Z")
Check the links below for more detailed explanations of each of the two column types: > **[Relations | Glide Docs](https://www.glideapps.com/docs/automation/computed-columns/relations)** > > Create relationships and link rows together. > **[Rollup Column | Glide Docs](https://www.glideapps.com/docs/automation/computed-columns/rollup-column)** > > Perform calculations on columns, such as count, average, and sum. ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [January 22, 2024, 10:26am UTC](https://community.glideapps.com/t/need-user-specific-total-of-the-column-based-on-login/69845/5 "2024-01-22T10:26:41Z")
@Darren_Murphy I tried it. Basically My table “A” has “Creator Name” and “Total Invoice value” table “B” has all creators list with a column called “Name” I created multiple relation to map Table A with Table B with Creator Name from Table A to Name from table B. I get stuck at this. How do I get Total Invoice value for creator with Name X? Just to clarify. Each Row is associated to creator. Row 1 ---- Has Invoice A — Creator 1 Row 2 ---- Has Invoice B — Creator 1 Row 3 – Has Invoice C ---- Creator 2 Row 4 ---- Has Invoice D — Creator 1 I am not sure how can we handle this case? ---
**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 22, 2024, 10:33am UTC](https://community.glideapps.com/t/need-user-specific-total-of-the-column-based-on-login/69845/6 "2024-01-22T10:33:12Z")
Okay, so you can do it in either table, but it probably makes sense to do it in Table A (the one that lists your creators). So in that table add two columns: - The first column is a multiple relation column that matches the creator name in Table A with the creator name in Table B. - The second column is a rollup column. This should target the relation column and take a sum of the invoice values. This should give you a separate total for each creator. Side note: linking tables by names is extremely fragile and easily broken. A better approach is to use some sort of stable identifier such as an email address or UserID. ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [January 22, 2024, 11:21am UTC](https://community.glideapps.com/t/need-user-specific-total-of-the-column-based-on-login/69845/7 "2024-01-22T11:21:15Z")
Thank you @Darren_Murphy let me try that and get back to you. BTW, I just realised. If my airtable is a “Link to Another Table” data type it will not show up in the relation linking. ---
**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 22, 2024, 11:24am UTC](https://community.glideapps.com/t/need-user-specific-total-of-the-column-based-on-login/69845/8 "2024-01-22T11:24:44Z")
Sorry, I’ve never used Airtable, so I don’t really understand how it interacts with Glide. But I do know Glide - if you can show me a screen shot of what this all looks like in the Glide Data Editor I can probably advise you further. ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [January 23, 2024, 11:40am UTC](https://community.glideapps.com/t/need-user-specific-total-of-the-column-based-on-login/69845/9 "2024-01-23T11:40:31Z")
Thank You @Darren_Murphy it worked. ---
**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:** [January 30, 2024, 11:41am UTC](https://community.glideapps.com/t/need-user-specific-total-of-the-column-based-on-login/69845/10 "2024-01-30T11:41:16Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.