# Sumatorio tablas **URL:** \ **Category:** Ask for Help\ **Created:** [December 11, 2022, 5:26pm UTC](https://community.glideapps.com/t/sumatorio-tablas/55656 "2022-12-11T17:26:57Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Joseagb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joseagb/32/36805_2.png) [@Joseagb](https://community.glideapps.com/u/Joseagb)\ **Post date:** [December 11, 2022, 5:26pm UTC](https://community.glideapps.com/t/sumatorio-tablas/55656/1 "2022-12-11T17:26:57Z")
Buenas tardes tengo una consulta a ver si me podéis resolver. Tengo una tabla en la que tengo la siguiente estructura. Usuario identificación Lugar trabajo horas trabajo ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/7/87d2dd1f713f59c12acc911be16a44c0bcbb6917.png) Lo que me gustaría es mostrar en una tabla las hora de trabajo del usuario es decir: Juan ha trabajado 8 horas en la zona 1. Juan ha trabajado 8 horas en la zona 4. Pepe ha trabajado 9+12 (21) horas en la zona 3. Un saludo y gracias de antemanos. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [December 11, 2022, 6:05pm UTC](https://community.glideapps.com/t/sumatorio-tablas/55656/2 "2022-12-11T18:05:00Z")
- Add a RowID column to your table. - Create a Template column that joins the identificación and lugar columns together. - Create a Relation column that links the template column to itself. - Create a Rollup column that sums the hours from the relation. - Create a Single Value column that returns the first RowID from the relation. - Create an IF column that returns the Rollup sum if the Single Value RowID matches to row’s RowID. - Add an inline list to your screen, point it to your table, and filter it to only show rows where the IF column value is not empty. ---
**Author:** ![Joseagb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joseagb/32/36805_2.png) [@Joseagb](https://community.glideapps.com/u/Joseagb)\ **Post date:** [December 17, 2022, 2:35pm UTC](https://community.glideapps.com/t/sumatorio-tablas/55656/3 "2022-12-17T14:35:36Z")
Gracias por la ayuda, pero no lo consigo. ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [December 19, 2022, 12:19am UTC](https://community.glideapps.com/t/sumatorio-tablas/55656/4 "2022-12-19T00:19:38Z")
Hola! Tu caso se parece a este que indico abajo, es casi lo que Jeff intentó explicarte. > [@Counting/ Rollup Certain Values within a relation field](https://community.glideapps.com/t/counting-rollup-certain-values-within-a-relation-field/55759): > > Hi Everyone! I am currently working on a maintenance app for a manufacturer. One part of the app is that you can log maintenance call out to a machine, should it be down and need fixing. Each call out is is related to a machine and they each have their own dedicated table. The question/ issue I am having is that I am wanting to create a roll up from the relation field based on the status of the call outs (Ongoing, On Hold, Completed) so that when you are viewing a machine within pages you can … Espero te sirva, saludos! ---
**Author:** ![Joseagb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joseagb/32/36805_2.png) [@Joseagb](https://community.glideapps.com/u/Joseagb)\ **Post date:** [December 20, 2022, 8:21pm UTC](https://community.glideapps.com/t/sumatorio-tablas/55656/5 "2022-12-20T20:21:49Z")
lo revisare. Gracias