Skip to Main Content
Status Shipped
Categories Reports
Created by Guest
Created on Aug 18, 2017
Merged idea

This idea has been merged into another idea. To comment or vote on this idea, please visit APP-I-6831 I'd like the ability to filter in a report by the top/bottom # of ranked items.

Ability to limit rows or columns of pivot table and chart Merged

When creating pivot tables and charts, I would like to limit the number of rows or columns by using filter. The easiest option could be to allow filter like Top 10, Top 20, etc. More specifically, it would be great to filter the rows or columns by cell values. For example, I would like to exclude columns with total sum of cells less than 2. 

  • Yancey Larochelle-Williams
    Reply
    |
    Sep 29, 2021

    I'm looking for something similar. As it stands, the team currently struggles to cut through the noise because of the volume of ideas coming in. It'd be nice to be able to say:

    "Here, leadership - here are the top 20 ideas for all the teams you manage, by agreed-upon parameters, and here are the added data points around them - customers who asked for them, number of votes overall and scoring/weighting for the idea".

    Currently, the report I just described is actually 1 report per workspace (35 in our case) and if you want to see this all in a single pivot chart, it becomes unreadable since we can't limit the rows at all.

  • Omar Ghazi
    Reply
    |
    Sep 28, 2020

    This would be extremely useful. Especially with the new Dashboard feature that was rolled out. A couple of use cases I ran into when I could've used:

    • Top 10 (or x) idea submitters

    • Top 10 (or x) ideas for individual idea status

    • Top 10 (or x) ideas based on # of vote

    Along with the top x, it would be super useful to be able to sort based on the total column or the cell value on a pivot as highest to lowest or vice versa

    These are some of the crucial features preventing me from using the new Dashboard feature to a further extent

  • +1