Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Sum Value in two different table based on a single date filter

Hi Guys, So i am not sure the subject properly describes the issue, so i'd explain. So i have two different tables (import from SQL)   Table One Contains All Transactions (2012 - Date) Table Two...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks for the feedback. So here is a summary.

1. I have created the date calender table

2. I have also linked the two tables to the calender tables using the date column.

3. However, one of the relationship is currently inactive and so the NewCalender filter only shows results from the active table relationship

 

See attached,

 

sevenhills's avatar
sevenhills
Super User
6 years ago

Try deleting the relation and recreate ... once the relationships are active, then it should be good.