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?