This content has been marked as final.
Show 3 replies
-
1. Re: Same time last year reference line
Shinichiro MurakamiJul 6, 2016 9:39 AM (in response to Matthew Hefferon)
Does this work?
[Last Year to Date]
if year([Date])+1 = year({fixed : max([Date])} )
and [Date] <= dateadd('year',-1,today()) then [Net Sales] end
Thanks,
Shin
-
Dummy Bar Chart 9.3.twbx 48.4 KB
-
-
2. Re: Same time last year reference line
Aiswarya Sundaram Jul 6, 2016 9:42 AM (in response to Matthew Hefferon)This calculation should help you.
if DAY([Invoice Date])<=DAY(TODAY()) and MONTH([Invoice Date])=MONTH(TODAY()) and YEAR([Invoice Date])=YEAR(TODAY())-1
then [Net Sales]
END
I have assumed your data set is on daily basis and that you are looking at Jul until 6th of last year.
Tweak it a bit to match your needs otherwise
Then create a reference line with this field with per pane scope.
-
3. Re: Same time last year reference line
Matthew Hefferon Jul 6, 2016 10:14 AM (in response to Matthew Hefferon)Sounds good! Thanks for the help everybody!