11 Replies Latest reply: Jul 7, 2011 5:43 AM by Jonathan De Deken RSS

    How to only display CURRENT details

    Chris Hopkins

      Hi, I am trying to create a chart that displays CURRENT stock levels of products in our retail stores. I only want to display the latest record regardless of the date selected but users can make other selections such as Retiler or Dept Name etc.

      I am guessing it would use the latest file received and processed going by the date field (which is StoreDate)

       

      Basically i want it to ignore any selection to do with date (any made from the top row), but i want it to use any selction made from the left hand side.

       

      I have attached a sample of my document.

       

      Can anyone help me please?

       

      Thanks in advance.

      Chris