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