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

    Sort secondary data source dimension

    bhargavi chittibomma



      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