3 Replies Latest reply on Oct 26, 2016 6:22 AM by damodar.bhalerao

    sum of Sales upto a particular date

    Jamil Ahmed

      Hi,

      Would like to get some urgent help with the below topic.

      My worksheet is to display a variance of Actual and Estimated quantity.

      The difficulty is I have to show the variance between the same. Now when I select a particular month I do get the variance accurately but my requirement is to get the variance of Sales upto the month selected(and not just that month, basically its the cumulative sales) and the Estimated Sales.

      Attaching the excel file of dummy data.

       

      I am able to get the solution, if I do select all the dates, but I need it when i do select just one month, and I get the sales upto the month and not just for that month.

       

      Thanks,

      Jamil

       

      Message was edited by: Jamil Ahmed