If you are presenting the data in table format,
maybe you can try this calculation:
It will lookup the Grade in the Row before the PRO.
209511pro.twbx 19.6 KB
I appreciate your follow-up. I should've done a better job clarifying my problem.
The underlying raw data is structured in the following way:
I created a table in Tableau that looks like this:
Name New Grade Old Grade
John D 8 ?
Steve A 10 ?
Peter T 7 ?
The "Old Grade" would have to be determined logically. I don't believe the Table Calculation is the solution I'm seeking. I'm needing help or needing to know if its even possible to basically read the raw underlying data and logically return the grade prior to the promotion row within the raw data set.
I'd prefer to NOT calculate this in excel and I'm wondering if there's a way for Tableau to do this? Would this require the use of RAW SQL?
I hope this makes sense,
My apologies, I didn't quite catch.
It is possible that table calculations won't work for your setup.
Just wanted to clarify the results you are seeking.
Using the table calc method, I got the below results (sheet2 of the attached)
but they do not match your results table above:
John D NewGrade of 8 vs. 10
Steve A NewGrade of 10 vs 9.
Please clarify how those New Grades are derived from the raw data.
Sorry for another round.
209511pro.twbx 19.9 KB
This clarifies perfectly. This really helped me bridge a knowledge gap as well. I really appreciate your willingness to assist with this.