Good morning, I am looking for a way to sum the records of a column that have in common a value in another column, and it refers to another column as shown in the image.
In the image I show two tables, the first table has the ID VIATICOS and the total refers to the sum of the records that coincide with the ID VIATICOS in the second table.
I use the following formula:
=SUM (FILTER (Descripcion_viaticos, "Descripcion_viaticos[ID VIATICOS] =%," [ID VIATICOS]") [TOTAL POR COMPRA])
THANKS FOR YOUR SUPPORT