I had a table that has a QUERY, where this QUERY sum´s and filter data for [Customer], by [$ total spend], [year] and [weeknum].
At this table I had this formua in a virtual column: SUM(SELECT(Query[$ total spend],[Customer]=[_THISROW].[Customer]))
Also had a virtual columns that belongs to the current weeknum
How can I filter the SUM formula to show only the total SUM for the current week of the year for each customer?