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








      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?