6 Replies Latest reply on Dec 6, 2013 6:23 AM by Eric McDonald

    Filter Logic Required

    Eric McDonald

      I have what looks like a simple example but can't work out how to create the filter I want.

       

      I have uploaded a packaged workbook with a sample data-set to illustrate the problem. The data looks like this:

       

      StockFundIndex
      Microsoft020
      Oracle2025
      Tableau3015
      Google015
      eBay5025

       

      I want to provide users with a filter / parameter which has the following exclusive choices (i.e. radio buttons):

       

      Show Fund Only Stocks

      Show All Stocks

       

      I can't find an easy way to do this. You can create a calculated filed Fund != 0 which when True shows Oracle, Tableau, and eBay and when False (correctly) shows nothing. However the logic I want is to show Oracle, Tableau, and eBay when Show Fund Only Stocks is selected and all stocks when Show All Stocks is selected.