3 Replies Latest reply on Aug 31, 2012 1:57 AM by Chris Fisher

    Parameter used to set value of a filter

    john wilson



      I have a situation where I have multiple users across multiple departments.  I have departments on the filter shelf.  What I want is to create a parameter whereby the user selected sets the values for the departments filter.  I have the parameter for the users set, but I need to create the calculated field that determines the values of the departments filter.


      For example, if "Smith" is selected, the filter will be set to values 1,2 5, 6 but if Jones is selected the filter will be set to the values of 1, 5, 8, 9


      Something like that.


      Can anyone suggest if that is possible...I have used parameters in calculated fields to show or hide (From reading this forum), but haven't read anything about what I am attempting.