Ranking Table Question

I am trying to make a table comparing performance of each step of a project (drilling a well) across multiple projects (wells).  Right now I have built a cross table using a rank function to generate the ranks for each step in each well and highlight the #1 rank.  This is what it looks like:

What I would like to do is put the rank along the top axis and have the value field return the Well name for that rank.  I am using the rank function as a custom expression instead of calculate column.  I am doing this because I want the rank calculation to run based on a selection of wells that I have marked dynamically instead of over the entire dataset.  This is the rank function I am using:

Sum(if([Test]="Flat Time",Rank([DURATIONACTUALCALC],"asc",[CODE1]),Rank(([DEPTHENDACTUALCALC] - [DEPTHSTARTACTUALCALC]) / [DURATIONACTUALCALC],"desc",[CODE1])))

 

Does anyone have any ideas on how to pull this off?

(2) Answers

Login