Rank in Pivot Table



I created a pivot table that shows sales by customer by month. I grouped the
months into quarters. Now, I would like to rank the customers by sales for
each quarter - give each customer a rank for Q1, Q2, Q3, Q4 sales. Is
ranking possible in a pivot table? And, is it possible to have a rank for
each quarter?


This partially worked for me, is there any way to control dublicate values,
as we are displaying "Running Total" so every next value is given a No. which
is 1+pervious value, even if the Rank value is equal to previous value:

Value Rank
10 1
9 2
9 3
7 4

both 9 shold be 2, any solution?

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question