Skip to main content
New Idea

Ranking in Pivot Reports

Related products:None

steve_davis
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. 

3 replies

sai_ram
Forum|alt.badge.img+1
  • Expert ⭐️⭐️
  • 3727 replies
  • August 7, 2018
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. 

steve_davis
Forum|alt.badge.img+2
  • Author
  • Gainsight Employee ⭐️⭐️
  • 201 replies
  • August 7, 2018
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.)







mary_taylor
Forum|alt.badge.img
  • Contributor ⭐️⭐️⭐️⭐️
  • 31 replies
  • March 11, 2020

When I pivot on a date field (aggregated by month) I’d like to see the months in descending order in the result table vs ascending (e.g. Current month, previous month…. etc vs Jan 2020, Feb 2020, Mar2020 etc) I want to see most recent month first


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings