1 Reply Latest reply on Nov 13, 2016 11:51 PM by Pavani Donepudi

    Unique requirement of Filter

    Santu Ghosh

      Hi,

       

      I have a unique requirement for filter. We do estimation services for lots of items. We need to track our performance based on a range of deviation of actual prices with our estimated prices. We need to represent both the outside and inside range in the same table. I am providing an example. This is my sample data:

       

               

      DateMonthLot No.Lot Qty (MT)DescriptionEstimated PriceActual PriceDevn %+/-2%+/-1%+/-5%
      10/Sep/16Sep'16Lot1100Mat116500163001.212WithinOutsideWithin
      10/Sep/16Sep'16Lot2150Mat218200182000WithinWithinWithin
      10/Sep/16Sep'16Lot3160Mat11820019000-4.396OutsideOutsideWithin
      10/Sep/16Sep'16Lot4200Mat11900019200-1.053WithinOutsideWithin
      10/Sep/16Sep'16Lot5250Mat219500190002.564OutsideOutsideWithin
      10/Sep/16Sep'16Lot6300Mat21830019000-3.825OutsideOutsideWithin

       

      I want the following report if I put filter criteria as Deviation and select X%

       

      If x=2 then this will be the result

       

          

      DescTotal Lots+/-2%
      WithinOutside
      Mat1321
      Mat2312

       

       

      Regards,