Top N Pivot Anomaly

P

PatK

Having an issue, with a top 20 pivot. May be a simple answer, but I cannot
figure it out.

I have a data table of "support tickets", for 6 months (about 20K) rows, in
excel 2007. Each ticket has a category. I want to pivot the file for the
top 20 categories of tickets, by month (Category as row header, Month/Year as
Column Heading).

Issue: when I select JUST the most current month and filter for Top 20, I
get a set of, say 2000 support tickets. However, when I add other months, my
current month always goes down in count. My guess is that one of the other
columns (months) becomes KING of the top 20.

PatK

I want my top 20 to be based on the current month, and who the counts of
tickets in other months, associated with that same category. I don't want
another month to decide what the top 20 is.

Maybe I fundamentally am not understanding how Top N filter works. It is
fine with just one month...I get exactly what I would expect, but when I add
more months, it changes, and I cannot figure out why.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top