Dynamic Tables
AnsweredI am in the process of building a dashboard to show the status of our who does what schedule. One of my charts it top 5 people with the most things outstanding. Is there a way this automatically updates? I have filtered a table and linked the top 5 to the chart but when i change the values, the people in the top 5 do not update. Any way we can do this without manually updating every time I want to use or send the dashboard? Thanks in advance.
0
-
i tend to create a "presentation" table off to the side (or on another tab) that looks up the 5 names that you want to present. I'd look up the values 1-5 off of a helper column in the complete list that uses the RANK function to determine the sort order. would look something like this (link cells in yellow to your presentation).
that should work, but someone else may have a more efficient idea.
0
This works amazingly! Thank you Ben! 0
Ben do you have any suggestions for when people are tied on things outstanding? If two people have 13 outstanding it only shows one of them the other is NA.. Shouldn't happen too often but do you have any way of dealing with this? 0
I hadn't run into this (because i'm doing it on GL data which never matches exactly), but I google'd a quick solution. you just have to get clever with the formula to increment duplicates. pay special attention to the way the countif range is locked with the $. You only want it to extend from the top to the current row, but not past. 
0
Comments
5 comments