9 Replies Latest reply: Feb 29, 2016 12:55 AM by jagan mohan rao appala RSS

    How to manage sales by month ?

    Yeo Poh sai

      Hi All

       

      When i using QV to present YTD sales or YTD month close sales.  For example Now is Feb 29.

      I can use the SET expression to present the sales.

      1 Jan till 29 Feb sales. YTD month closed. by select month=2.

       

      sum({$<year = {$(=max(year))}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} $(ColumnDim51)/$(Columndim89)/1000)

       

      1 Jan till End Jan sales. YTD month closed. by select month=1. using the same above expression.

       

      When i using QS i can only present YTD sales or YTD month close sales. Due to it does not advise to make use of button to set month = 2 , I need to make use of 2 expression ,in order to display YTD sales or YTD month close sales.

       

      As one thing i notice , from the demo program for QV , every page have month for user to click . where in QS design , it does not have month field year field for user to click the month and year they like.

       

      Hope some one can advise me what is the work around ?

       

      Paul