View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KrispyData KrispyData is offline
external usenet poster
 
Posts: 24
Default 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?