5 Replies Latest reply: Feb 23, 2016 6:22 PM by Ankit Luthra RSS

    How to show percentage of total instead of absolute numbers

    Ankit Luthra

      Hello,

       

      QuikSense newbie here. I am trying to show Female vs. Male percentages by Job Level, and have absolute numbers in my data. Sample data below:-

         

      Job LevelFemaleMaleTotal
      Executive165190355
      Director110012002300
      Manager6500640012900
      Professional122001150023700
      Manufacturing155001450030000

       

      I want to create a bar chart, but instead of showing absolute numbers, I want to show percentages of Female vs. Males. Something like this:-

       

       

      I understand I will need to create a custom measure, like Female/Total *100 or something. But not sure what formula to use.

       

      Thoughts?

       

      Thanks in anticipation!

      Ankit