5 Replies Latest reply on Aug 16, 2017 12:16 AM by Yasser Alsaadi

    Filtering for a DIMENSION for Latest DATE

    Yasser Alsaadi

      Hi

       

      I have a set of data that's grouped monthly, it goes back a couple of years. What's displayed is the latest 2 months - this is simply done through filters > top 2 for date. That's easy enough.

       

      There's a set of data every month for products whether they're "In Stock", "Low Stock", or "Out of Stock".

       

      What I want to do is look in the LATEST month, and exclude "In Stock".

       

      I have tried creating parameters and a calculated field using contain, but this doesnt solve my issue really because it will exclude all of "In stock" for every month, when in fact I only want it to exclude "In Stock from the latest month.

       

      ORIGINAL DATA

        

      ProductJul-17Aug-17
      1In StockLow Stock
      2Low StockSold Out
      3Low StockIn Stock
      4Sold OutIn Stock
      5Sold OutSold Out
      6Low StockLow Stock

       

      HOW IT SHOULD LOOK AFTER FILTER

       

        

      ProductJul-17Aug-17
      1In StockLow Stock
      2Low StockSold Out
      5Sold OutSold Out
      6Low StockLow Stock

       

      So what we've done is removed product "3" and "4" because they were both "in stock" for august and i dont need that. If you see we still keep product "1" because we're only looking at the latest date which is August.

       

      Hope that makes sense guys.

       

      Thanks

       

      Yass