I am trying to show current weekending sales in a straight table column and the prior year weekending date sales in another column. The expression for the current year is straight forward (i.e. Sum(Sales) ). However, I am having trouble getting the prior year weekending date sales. I tried the following expressions to not success.
Attached is the sample data set to compute the Prior Year Week End Date.
I researched the forum extensively before posting this issue but, could not find a posting pertaining to my question. A few were close to my question but, could not get it to work.
Thank you in advance for any assistance.