19 Replies Latest reply: Aug 29, 2018 11:45 PM by Shraddha Gajare RSS

    Need logic for distinct count of field in 1 week only

    Shraddha Gajare

      Dear All,

       

      We have to build a logic to count of brand sold particular month/Year.

      however, we have to display this data w,r,t Week.

      If one brand is sold in 1st week then it should not be counted again in another week of that month.

       

      And this logic should work as per selection of Month/Year.

       

      Sample Data:

       

      Brand, Week, Area, Zone, Division, Month, Year

      A, 1, Area1, Zone1, D1, JAN, 2018

      A, 2, Area1, Zone1, D1, JAN, 2018

      B, 2, Area1, Zone1, D1, FEB, 2018

      B, 3, Area1, Zone1, D1, FEB, 2018

      C, 1, Area1, Zone1, D1, JAN, 2018

      C, 4, Area1, Zone1, D1, FEB, 2018

      A, 4, Area1, Zone1, D1, MAR, 2018



      stalwar1


      Thanks in advance