4 Replies Latest reply on Oct 12, 2017 1:40 AM by Imran Azam

    filter settings help please

    Imran Azam

      Hi guys

       

       

      i have a filter problem , i have a example reports attached , what i am trying to do is set defaukt

      filters based on the location the user chooses

       

      when the user select leeds, i want the following filters to selected from the relevent options GROUP: water RATE:5 and colour: red

       

       

      when the user selects London , i want the filters to change from above and select all relevant options for each filter

       

       

      also i just want relevent data to appear for each filter depending on which location is selected

       

       

      can this be done?

       

       

      i have attached a worksheet