6 Replies Latest reply: Nov 12, 2013 10:40 AM by Hanna Sofia Joakimsdottir Alderton RSS

    last stock value per Items in warehouses

      Hello,

       

      I need to create a stratight table displaying the last entered value for an item but I dont seem to get around it. I have seen other questions like this but they have still not been answered.

       

      I need to create a list displaying each Item and its last entered value. In my source data I have "Revision date" that I could use but I dont want to filter in extraction but rather do this in a set analysis.

       

      had it been in SQL I would have dome something like:

      select A, B,  Max(Date)

      Group By A,B

       

      Resultset would be:

       

      Item 1, 100, 2012-12-31

      Item 2, 60, 2013-05-04

      Item 3, 140, 2013-11-07

       

      How do I get this in a chart in QV?

       

      similar problem as in Stock management - How to extract a stock value from a maximum date. but this is not answered...