1 Reply Latest reply on May 11, 2016 5:39 PM by Manideep Bhattacharyya

    How can I make my parameter dynamic so that salespeople can only view the performance of other salespeople in their region?

    ailsa.zheng

      2016-05-11 16_00_29-Tableau - Sales Dashboard 5-11-2016-02.png

       

      Hello,


      Here is a dashboard I built (sorry for all the blurring but I didn't want to risk getting in trouble). On the top-right, encircled in red, is a parameter with the name of every ASM (Area Sales Manager) in my company.

       

      The directors want each ASM to be able to view the information for everyone in their department. For example:

       

      EAST

      John

      Janice

      Jacob

      Jerry

       

      WEST

      Blake

      Boris

      Betty

      Bob

       

      John needs to be able to select John, Janice, Jacob, and Jerry on the ASM parameter, but should not be able to select Blake, Boris, Betty, or Bob. Blake can select Blake, Boris, Betty, or Bob, but not select John, Janice, Jacob, or Jerry.

       

      Is there a way I can do this with a parameter? It has to be a parameter my data comes from multiple data sources. Sorry I can't attach a workbook, it's highly sensitive, plus it's all permission-based so I don't think it will help anyway.