Hi,
I have report with Current and Prior yr counts.(based on YTD)
query1 is current yr
query 2 is prior yr
query 3 is current and prior yr.
this is my 34th week. For 34th week I have 0 count for current year but I have some count for prior yr. Here is my question 34th week I donot have counts so I donot need to show up Prior yr also for this week how can I get this. for both prior and current yr counts should whop up upto 33 week.
thanks in advance.