3 Replies Latest reply on Apr 2, 2018 7:27 PM by Ashok Ramineni

    Hide Sheet for multiple selection on Action Filters

    Ashok Ramineni



      I have a sheet 1 with Sub-Category & Profit. Sheet 2 has Region and Discount fields.


      I have created an action between Sheet 1 & 2, however data will display for the selected Sub-Category values, which is default behavior of Actions.


      My requirement is, when user selects

      1. Single value from Sub-Category, then Sheet 2 should be visible or pop-up

      2. Multiple values from Sub-Category, then Sheet 2 should be invisible or hide or show blank screen.


      which means that when selected single value from sheet 1, then Sheet 2 should display else should be blank.


      Please let me know for any work around.