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.
New Idea
Ranking in Pivot Reports
+1Hi 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.
+2Hi 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.)
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.)
1 person likes this
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
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.