0 Replies Latest reply: Dec 8, 2016 6:17 PM by Yeo Poh sai RSS

    After add sales target 2017 my max year now 2017 . How to remove  2017 ?

    Yeo Poh sai

      HI All

       

      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.

       

      PAul