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

    Parameter used to set value of a filter

    john wilson

      Hi,

       

      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.

       

      John