I need to sum a column that has a filter on a repeating table. I know how to do it but I get the sum of all the rows instead of the filtered ones. Is there a way to sum a column that has filter on a repeating table?
Add the same filter to your sum function.
So sum(field1[Field2 = X]) as an example