After I add my sales target for 2017 . Now QV detech my max year = 2017 instead of 2016.
most of the report now display null . And user need to manually click on year=2016 , then it can display the figure.
SInce I am lazy to delete all sales target 2017 figure from excel , may I know how to make use of script to remove year =2017 data ?So that user can view the report as normal.
what i know is not using script , that is manually select year <2017 and do the reduce save and keep all possible value.