Ranking in Pivot Reports

  • 2
  • Idea
  • Updated 2 months ago
  • Under Consideration
I have a customer request to be able to apply ranking to a pivot report. The specific request is to be able to sort/rank by whatever the customer chooses. For example:

If the pivot report is cases month over month, give the user the ability to rank based on either overall case count or most cases last month etc. 
Photo of Steve Davis

Steve Davis, Employee

  • 7,926 Points 5k badge 2x thumb

Posted 5 months ago

  • 2
Photo of Sai Ram Pulluri

Sai Ram Pulluri, Official Rep

  • 13,270 Points 10k badge 2x thumb
Hi Steve, We support ranking on Pivoted reports today, could you please explain in detail what is the exact use-case(report) you are trying to achieve. 
Photo of Steve Davis

Steve Davis, Employee

  • 7,926 Points 5k badge 2x thumb
Hi Sai, 

If you try to add Ranking, it doesn't give anything logical. What its doing is taking the top values like this. Essentially what I want is what I did in excel where I exported the report, created a "Total" column which shows how many total tickets submitted over that time period. I'd like to "Rank" these 20 (for example) accounts and be able to have a concise list that consistently updates what are my top X accounts. Does this make sense? Also, you cannot apply ranking when summarized either so the only thing you can rank is what the date field is (date, date/time, etc.)