Show data only for last week when multiple tables have data

Hi richard_jackson I would merge multiple transaction tables into one summarized table by grouping Sum(Amont) by Date and then create a Calendar table with one to many relationship to the summarized table. I can then use the Date column from the Calendar table as slicer with Relative Date option to filter results by last 1 week, month etc. 

Hope this helps.