Sum last week filtering two tables

joshua1990 · ‎04-13-2020

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:

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 · ‎04-13-2020

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

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

Helpful resources