Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm trying to show current and last year's weekend date sales (see attached). I am using a variable below to calculate last year's weekend date. The text box shows that the variable is working because I have a filter on the weekend field set to 5/27/2017 and the variable is showing the comparable date last year. The issue is that the "All Fuel Types Prior Year" column in the straight table is showing the filter date (i.e. 5/27/2017) value and not the value from 5/28/2016.
How anyone seen this issue before? Thank you in advance for any assistance!
Variable:
vPYWeekending: =Max(FormattedWeekEndDate)-364
Expressions:
Changing the quotes did not work. I tried that previously. This is strange....