I have been trying to find a calculation that will allow me to show the sales data for a week day and then the sales data for the same day last week. I have the date calculation part figured out pretty easily, but I can't find the solution to getting the sales numbers to populate.
I am not looking for a summary but just a straight number from the prior week day.
I am guessing this will be a simple solution but I just cannot find it.