0 Replies Latest reply on Jan 31, 2012 10:02 PM by Kenneth Ho

    How to calculate and display percentage of the measure value on dashboard

    Kenneth Ho

      Hi all,

       

      I am creating a dashboard base on some raw data.  I have created 3 sheets; 1) job count A 2) job name 3) job count B and a dashboard.  I was trying to show a global filter where i  pick a job name, and the dashboard will show how many jobs are working under that job name. The job count B will show the total job count in the department.  I want to create a percentage of count A / count B.  so everytime i pick a new job, the count A and % count will change.  What should I do to make that happen?

       

      Thanks