2 Replies Latest reply on Jun 26, 2016 3:22 PM by Dmitry Chirkov

    Filtering on 1 sheet, second sheet should show all

    arundhati.gutta

      I have sheet number 1 with for example Item id and Item Description

       

      in the first sheet I have a filter for Item description

       

      I should get all the Itemids for the filters selected in item description.

       

      In the second sheet there should not be any filter applied I should get all the item descriptions

      on the selected Item ids from the sheet 1

       

      I tried Worksheet Actions and Dashboard Actions did not work

      I placed both the sheets on Dashboard

      sheet 1 with the show Filter

       

      sheet 2 at the bottom with out filter and made the sheet 1 as Use as Filter but

      it allways bring the filters that has been applied on Sheet 1 in the sheet 2

       

      sheet 2 should have all the descriptions associated with that item id.

       

      any input or ideas how to achive this

       

      Thanks