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

    Filtering across multiple data sources

    suvas.chandra

      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]

      END

       

      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]

      END

       

      [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 ?