Hi,
I have the following problem:
values of a field (District) are been renamed from July 2015. I have a mapping table in order to match old values with the new ones.
In my dashboard Users was able to compare the sum of a certain quantity in the current selection of Year-Month with the previous year-month (ex: 201506 vs 201406).
But now, if they select a District in 201507, value of 201407 is 0, because that new value is not in the past.
Furthermore, the list box of District must contain old and new value, not just the new ones: so I think the mapping table must be linked to the calendar.
I attached sample data with some other detail.
Thanks in advance!
Elena
