2 Replies Latest reply on Dec 1, 2016 8:40 AM by James Malone

    Filter down to specific situations

    James Malone

      Hello, I assume the answer to this problem is a level of detail expression however I am not great at them yet and can't get this one to work!

       

      I have 3 products and the prices of them over 10 days, tracking price increases and WHO increased the price. I would like to be able to filter out the fruits where James hasn't increased the price at all (i.e. in this situation it would filter down to Bananas and Plums and exclude Apples as only John raised the price of apples).

       

      I have attached a packaged workbook.


      Thanks in advance.

      James