HI!

I attached a picture of the pivot table I am using. I need to rank column F first and then column M. That will then correct my ranking formulas on the right.

However, the pivot table doesn't really give me an option to do layered sorts like I can do to data without the PT, or atleast I haven't found a way yet. Can anyone help me?

Thanks!