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