Is there a way to only show relevant rows in a hierarchy filter?
I have a dashboard that has a hierarchy filter from Cost Centers -> Jobs
(i.e. Cost Center A has 1M in Cost. When I click on it, the Jobs grid card updates to show 10 different jobs that make up that cost. But 2 of those Jobs has $0 cost.)
I don't want those 2 Jobs to show up since they are not relevant to the $1M for Cost Center. It will make the grid smaller and stop unnecessary scrolling.
Appreciate any ideas.