Thank you very much for posting a workbook. However, in order for any of us to open it without errors, you'll need to publish a packaged workbook (.twbx). Otherwise, there is no data and we don't have your original source.
Thanks Joshua i was new to tableau and i uploaded wrong file. I figured out how to do the Ranking while grouping data. i will close this discussion.
Can you please post the solution.
It might be helpful to some one looking to solve the same problem..