4 Replies Latest reply: Jun 14, 2011 10:40 AM by jefmichielsen RSS

    Sales , with annulations taken into account?

      Hey all,

       

      I am struggling with a QV development problem for a week now. Now I ask for your help.

       

      Attached you can find an extract of the sales database of 2010. In the reporting I want to build, I want to compare the sales figures by month, but it should be the sales as it was at the time.

       

      An example will clarify this:

       

      If I select the month May, I want to see : Sales amount 0 + 120 + 210 + 30 =  360 (because line1 of order AAA is cancelled in May, and line 2 is only cancelled in September)

       

      If I select the month September, I would like to see : Sales Amount : 150 (order BBB) - 120 (line 2 of order AAA, which was cancelled in September).

       

      If I select the months January till September , I would like to see : 240 (order AAA) + 150 (order BBB)

       

      Can anyone tell me how to make this happen?

       

      Thanks in advance !

       

      Jef

        • Sales , with annulations taken into account?
          Deepak Vadithala

          Jef - Before I understand the requirement. I have couple of questions...

           

          1. how did you arrive amount as 120 . Your excel file does not show up any amount or quanity to calculate the amount.

           

          Your comment:

          If I select the month May, I want to see : Sales amount 0 + 120 + 210 + 30 =  360 (because line1 of order AAA is cancelled in May, and line 2 is only cancelled in September)

           

          2. You wanted to exclude the canceled amount right? Let's say for example the first row order is placed in May but cancelled in September. So what do you want to see when May, June, July & August are selected?

           

          Sorry I need more explanation.

           

          Thanks,

          DV