Forum Discussion
Sum of Values, comparing two fields from different tables
Super UserGottijay2000 , if first table is like a master table, then you can join it with both steps fields and one join will be inactive. You can activate join in a measure using userelationship
Hi amitchandak
the Steps table has unique values and Joins the Entries in a 1-Many relationship, but does not hold all the values the conditions require for the measure.
The StepsCrossJoin table is what i need to use as the main table as it holds the values the conditions will be run against. Only issue here is that it is a Many-2-Many relationship with the Entries Table.
i'm confused as how to make this work, where i can filter the Entries table for where the StepNoInital field = CrossJoin[StepNoInitialField] && StepNoFinal field = CrossJoin[StepNoFinal] field and then sum the amount.