Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Let me explain my issue with a example (app joined)
I have 3 years with CATTC (sales if you prefer) each month
i want to compare for each month :
évolution CATTC of the year Vs prévious year
&
gap between CATTC of the year and goal (goals are datas in a table ) (here is not my issues)
well i did that after created a calendar measure with CATTC
I have 2 issues in my visualization :
if i select only 2016, sum cattc YTD = sum CATTC YTD last year as you see ??
Secondly
if i select 2017 ... there is no value in previous year
anyone have a idea ?
regards
PS : i have i another solution (thank's sunny) by script in another threads, but i want to progress using CALENDAR MEASURE
I have not checked the file, but check my response here: