6 Replies Latest reply: Nov 12, 2013 9:35 AM by Srikanth P RSS

    Stock management - How to extract a stock value from a maximum date.

      Hello.

       

       

      I am working on a stock management for my industry, and I need to know what is the value associated to a period, or to a dimension.

       

      For example, in attacher file, I have got a short list a value.

      For exemple, I need to know what is the stock in the end of September. It should be 809.1 t

       

       

       

      BUSINESS UNIT

      STOCK

      DATE TIME

      MONTHSTOCK (tons)CYCLE OF PRODUCTION
      BUSINESS UNIT 103/10/2011 12:00OCTOBER 2011741,4BR553S
      BUSINESS UNIT 102/10/2011 12:00OCTOBER 2011776,4BR553S
      BUSINESS UNIT 102/10/2011 03:00OCTOBER 2011789,2BR553S
      BUSINESS UNIT 130/09/2011 07:30SEPTEMBER 2011809,1BR553S
      BUSINESS UNIT 129/09/2011 12:00SEPTEMBER 2011835,1BR553S

       

      I have to produce a dashboard like that, but I don't manage to create the expression.

       

      MAY 2011JUNE 2011JULY 2011AUGUST 2011SEPTEMBER 2011OCTOBER 2011
      BUSINESS UNIT 1468,4877,1724,5216,9809,1741,4
      BUSINESS UNIT 27855,25687,6100487764,497899789

       

      Is somebody can help me ?

       

      Best regards.