9 Replies Latest reply on Sep 7, 2018 7:51 AM by Brandon Kidwell

    Sort secondary data source dimension

    bhargavi chittibomma

      Hi,

       

      I have the below requirement

       

      I need to sort the dimension field which is coming from secondary data source and the measure YTD Ach% is calculated field from primary data source. But that calculated field is created using both data sources.

      SUM([YTD Actuals])/SUM([Sheet1 (2018 Corporate Portfolio Quotas v2)].[YTD Quota ])

      YTD actuals from primary data source

      YTD quota from secondary datsource

       

      Need to sort AE by YTD Ach% Largest to smallest

       

      Any help on this would be appreciated

       

      Thanks

      Bhargavi