3 Replies Latest reply on Jul 26, 2017 1:58 PM by Shinichiro Murakami

    How to create a Dynamic Title to display top 3 of a measure name or value?

    alexander.scheuch

      Hello all,

       

      I'm trying to figure out how to create a dynamic title to display ONLY the top 3 of a measure name or value.

       

      For example, the attached workbook:

       

      CURRENTLY SAYS:

      "Niger, Chad, Angola and 194 more represent the Top 3 countries in terms of Birth Rate %"

       

      MY GOAL:

      "Niger, Chad, Angola represent the Top 3 countries in terms of Birth Rate %"

       

      Is there a simple LOD calculation I could add to country and then insert it into the title editor?

       

      I appreciate everyone's assistance...