I use a master calendar for all my sales and ops reports.
Everything has been working fine however we've noticed an issue where if we select YTD and ROY form that list box, and then select previous year, so 2016, everything is fine and you see maxyear vs maxyear-1 sales and performance.
If you then select 2017 as the year, from year list box, the calcs roll on a year, ie 2017 vs 2016, however the 2016 value is for full year but the list box for YTD/ROY will only show YTD selected.
Adding in a current selection box does indeed show that YTD and ROY are selected as filters, but the YTD/ROY list box only shows YTD in green, ROY is greyed out.
Anyone else seen this, or am I missing something? TIA.
