Filtering / Dynamic Dashboard Question
stevedemo77 wrote:
I am struggling with something that seems like it shouldn't be so
challenging. I have a worksheet that contains 3 levels of data...region,
person, and total sales dollars. I want to have a separate worksheet where I
can select the region from a drop down list (done), then have it present the
top 5 salespeople based on total sales dollars. There are anywhere from 10
to 30 salespeople for each region, but I only want to see the top 5. Is this
possible, and what would be the easiest way to accomplish this?
Thanks.
Try a pivot table. Put region in page area, person in row area, sum of
sales in data area. Double click the person button, advanced, top 10
auto show, show top 5 using field sum of sales.
|