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