Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi.
I need to create a calculated dimension where, the dimension I need to use, is "controled" by the Year selected.
I have several dates in my system, but only one relates directly to Master Calendar. So I use Year (YYYY) in my list box, Month, etc..., from Master Calendar.
I have a chart where I need to use a dimension called DueDate (YYYY-MM), and its possible that this YYYY from DueDate doesn´t match Year from Master Calendar because they come from different fields.
I have another Year extracted from DueDate called YearDueDate (YYYY).
The point is that I need to use Year in selections, cause most data responds to it, but in some charts I need to use DueDate, where YearDueDate equals Year.
Example: RegistID=15201; Year=2014; DueDate=2013-10; YearDueDate=2013.
When I select Year=2014, my chart presents also this type of cases because they Year matches 2014, but in fact their DueDate is 2013.
I only want to show DueDate´s that match Year Selected.
Is this possible in calculated dimension, or another way? Till now couldn´t find a way by myself.
Thanks in advance.
Regards,
Bruno Silva.
Thanks,
It didn´t work. Returns error message "No Data to Display".
But with your answer, I´ve tried something just a little bit different... In Set Analysis, I´ve added
"YearDueDate={$(vSelectedYear)}". This variable already existed in my system and returns Selected Year.
Thank you very much!
Best Regards,
Bruno Silva.
it possible in set analysis, example: sum({<Year=,Year =YearDueDate >} abb)
this condition will will not select year even if u select year for particular chart.
Thanks,
It didn´t work. Returns error message "No Data to Display".
But with your answer, I´ve tried something just a little bit different... In Set Analysis, I´ve added
"YearDueDate={$(vSelectedYear)}". This variable already existed in my system and returns Selected Year.
Thank you very much!
Best Regards,
Bruno Silva.