Sum last week filtering two tables

[joshua1990]

Hey everybody!

How can I calculate the sum of a specific column in one table with a filter on this table and another one?

I have a table with this structure:

Date	Value	Status
01.01.2020	5000	AC
01.01.2020	5000	AG

I would like to sum up all values for the last week that have a status "AC".

The second table is a individual calendar table with a week column.

How would you do that?

[Anonymous]

https://www.youtube.com/watch?v=_quTwyvDfG0

https://www.youtube.com/watch?v=78d6mwR8GtA