5 Replies Latest reply on May 8, 2018 8:57 PM by Shinichiro Murakami

    Can a filter drive two sheets and show opposite results?

    Suvojit Basu

      Hi... Here is my question and attached is a twbx file (version 10.5.3) as example (please refer to the dashboard).

       

      There are two identical worksheets in the attached file showing Sales and Profit by Sub-category. The filter is from the worksheet "Subcategories Selected". The goal is the use the same filter to drive the "Subcategories NOT Selected" worksheet and show sales and profit of all the Sub-categories that are deselected by the filter. In other words, one sheet shows details of what is selected and the other shows the opposite (those not selected) by the filter. How can we achieve this?

       

      Thanks very much in advance for your help.