I have data at the weekly level that I want to use to show a side-by-side comparison of "This week" (being whatever week the user chooses) vs. "Last Week" (1 week prior to the selected week). Nothing fancy- I just want it in simple text form.
I've tried using calculated fields, but to no avail. I can get the week label to be correct, but the data displayed is the same for both weeks. Any thoughts?