18 Replies Latest reply: May 12, 2016 2:57 PM by subhasmita kar RSS

    Volume as per current month and Revenue as per YTD

    subhasmita kar

      Hello All,

      I need a help in finding out solution for my issue i.e. I have calculated my Volume as per current period(201603) selection and Revenue as per YTD(201603, 201602, 201601) logic. I am able to get the values for corresponding fields. Issue is that when I am selecting current period(201603), I should see only 2 rows(2nd table shown below), but I am getting all the rows because of my YTD logic for Revenue calculation. In conclusion I should see customers as per current period selection only not as per YTD. Please help on this.

         

      Input Data
      CustomerVolumeRevenuePeriod
      abc9067201603
      abc8934201602
      abc5981201601
      xyz2964201603
      xyz4592201602

       

       

       

         

      Ouput Needed when selected period as 201603
      CustomerVolumeRevenuePeriod
      abc90182201603
      xyz29156201603