Hi Guys,
I have a large data-set with monthly data ranging back to 2009, basically i am trying to create a time series plot for each ear under one graph from the same measure but using different months.
Can anyone tell me if it is possible to create calculation which will give me the sum of from my measurement for the year of 2016 Jan - December?
My Screenshot below might help explain the situation
Thanks in advance!
3 answers
Hi, Caomhan
Try this for 2016
sum(if year([Month Year]) = 2016 then [Total Referrals] end)
ZZ