1 Reply Latest reply on Sep 18, 2016 7:05 PM by Andrew Watson

    Ranking by language

    Phillip Money

      I would like to use, say, a slider bar to show the top N languages in a local government area. I have tried to sort on measure values, but to no avail. I have also tried to sort using a calculated field (Index), but this hasn't worked. I would appreciate any help.

        • 1. Re: Ranking by language
          Andrew Watson

          First you need to pivot your data to flatten it out, then create a combined field between your local government areas and the pivot field names (the languages).

           

          Create an INDEX() field to calculate the rank, from where you can use a parameter and calculated field to allow the user to choose the top x.

           

          Sorry for the brief description, the attached file showing the solution should make it clearer.