Multiple data rankings for individual pivot table

[thweatherford]

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!

[cbatrody]

Hi,

Welcome to the forum.

Can you post a sample template in excel format please?

[thweatherford]

Thanks for the welcome! I am glad I found this forum, it has a wealth of helpful information. The link below provides the URL where I have shared this document from a cloud client. I have tried to get the document under 1meg but it's difficult with the data and pivot table. I needed to keep a certain amount of the data so that my question makes sense. I just tested the link and it works.

I need to have the RMA data ranked first like it currently is. Once you scroll down you will see where there is no more RMA data to rank. It is at that point that the ROM data needs to begin being ranked in order. Let me know if you have anymore questions or need a better explanation.

Thanks again for help!!


https://drive.google.com/open?id=0B6...Uk0&authuser=0

[cbatrody]

Hi,

Can you upload the sample template here rather than a link to google drive? See the following URL for steps involved in uploading a file.

http://www.excelforum.com/members/da...ch-a-file.html

[thweatherford]

Is there a place I can upload over 1,000kb?