9 Replies Latest reply on Sep 10, 2016 9:09 AM by Rob Kime

    Create % using dynamic count of territories

    Rob Kime

      I would like to turn the Above / Below value into a percentage. I have created calculated measures (I think) for the numerator "A" (Count of Territories above the parameter) and the denominator "B" (Total Number of Territories) as well as the final calculated value I want which is A / B for the % of territories that fall above or below the "Greater Than Sales" parameter. Hope this makes sense? Any suggestions are greatly appreciated!

       

      Rob