4 Replies Latest reply on Dec 7, 2012 9:22 AM by Jonathan Anderson

    Ranking On a Calculated Field

    Jonathan Anderson

      Hi Everyone:


      I think I am just missing something here but I am looking for some help.  Unfortunately I can not post a workbook but I hope I provide enough info in the screen shots. 


      So what I am trying to do is sort my Graph (Graph.png) by the HSG Percent (Marks Card.png Highlited).  The HSG Percent are the orange values on the Graph.  I have set up a rank but I noticed that it does not allow you to look Calculated fields so right now it is looking at the number of overall policies in each state.  I do have the HSG Percent calculating my Reference lines so you cans see the values that I want to sort by.  Any suggestions would be appreciated.