2 Replies Latest reply on Dec 7, 2017 6:06 AM by suvas.chandra

    Filtering across multiple data sources


      Not sure whether my approach is correct. I have two data sources.


      I have created a calculated field from data source 1:


      Case [Select a Dimension]

           When "Investment Type" Then [Investment Type]

           When "Vehicle Type" Then [Vehicle Type]

           When "Vintage Year" Then [Vintage Year]



      I have created another calculated field from fata source 2:


      Case [Select a Dimension]

           When "Industry Focus" Then [ind_focus]

           When "Geography Focus" Then [geo_focus]



      [Select a Dimension] has all five dimensions mentioned above.


      The purpose is to create a pie chart and control by the parameter. What is the best way to do this ?