Would you please share the steps and possible screenshot for each case? It will help to better understand. I am sure experts will help you solve the mystery.
1 of 1 people found this helpful
Since we can't do sub-queries, I just added the filters to the column using a case statement and removed the filters from the entire report. This allows the weeks to come in, but filtering to occur, making the columns show a 0 for irrelevant data from previous years. Its not elegant, but neither is not being able to make complex joins.