10 Replies Latest reply: Oct 31, 2012 12:56 PM by tusharmehtadxb RSS

    Filtering of pivot chart

      Hello All,

       

      I would like to learn how to filer pivot chart result.

       

      example.

       

      In my below mention example, I would to filter result base on selection.

       

      Normal Display:

       

      Location CodeDocument NoItem CodeCost PriceSales Price (BD)Sales Return
      BR0011STK0011,000.009,000.00500.00
      BR0021STK0051,000.008,000.000.00
      BR0032STK0041,000.004,000.007,000.00
      BR0041STK0068,000.0015,000.000.00

       

       

      Filtering records where Sales Return is ZERO

       

      Location CodeDocument NoItem CodeCost PriceSales Price (BD)Sales Return
      BR0021STK0051,000.008,000.000.00
      BR0041STK0068,000.0015,000.000.00

       


      Filtering records where Sales Return is not ZERO

       

      Location CodeDocument NoItem CodeCost PriceSales Price (BD)Sales Return
      BR0011STK0011,000.009,000.00500.00
      BR0032STK0041,000.004,000.007,000.00

       

      To do that:

       

      It will be greate if we can do filtering through User defined value in list box, if not may be any other better way.

       

      I had attached example and modified my main post with result.

       

      Thanks in advance.