10 Replies Latest reply on Jan 7, 2014 3:35 AM by Jonathan Drummey

    Can I use a parameter to select which data source to use in a workbook?

    Alissa Volosin

      I have 5 data sources in my workbook,  one for each client.

       

      Data Sources

           clientA

           clientB

           clientC

           clientD

           clientE

       

       

      Each data source has the column "revenue."  I would like to create a view where I can select any client and view the revenue.

       

      Ideally I would like to set a parameter called "Client" to the 5 data source names.  This way I could create a calculated field in a sheet called Revenue and the calculation would be sum([Client].[revenue]) and based on which client I choose in the parameter, the revenue would be totaled from the appropriate data source.

       

      Is this possible? Or can you recommend a work around?