3 Replies Latest reply on Apr 20, 2018 5:00 AM by Luiz Nunes

    Item Count with FIXED condition?

    Luiz Nunes

      Hello all.

       

      I need to run an analysis were, using the following data set I need to identify these counts:

       

      Qty of New, Refurbished, Open items sold per quarter

      Qty of receipt that have ONLY New items sold per quarter

      Qty of receipt that have ONLY Rfrbd. items sold per quarter

      Qty of receipt that have ONLY Open items sold per quarter

      Qty of receipt that have mixed itemCond items sold per quarter

       

      Item unique identification is <<itemID, itemVer>>      

       

       

      IDreceiptIDcustomerIDitemIDItemVeritemNameitemQTYitemCondDate
      119291it0022wallet1New01/jan
      219291it1441toy1New01/jan
      319291it6581collar1New01/jan
      419291it0873shoes1Refurbished01/jan
      519291ti2322puzzle1New01/jan
      62745it0024wallet1Open02/mar
      72745it0872shoes1Open02/mar
      82745ti2322puzzle2Open02/mar
      939291it0029wallet1Refurbished06/abr
      1039291it6585collar2Refurbished06/abr
      114795it0871shoes1New02/jun
      124795it0023wallet1New02/jun
      134795it8702parfum2New02/jun
      144795it5581book3New02/jun
      1554887it0022wallet2Open01/jul
      1669291it1443toy4Refurbished05/nov
      1769291it8771blender1Refurbished05/nov
      1869291it3003tv1Refurbished05/nov
      1969291it6371duster1Refurbished05/nov

       

       

       

      Can someone help me this issue?

      Thanks a lot.