Pivot Table Show Top 10 Error

N

Native

Hello: Stumped as to why when I utilize a 10 top criteria, some of my
data points will show 11?

For example, I have house type going down the left edge of my pivot
table and colors as a subset of house type. I then have Years going
across the top.

I have a Field Settings...Advance...Top 10 Autoshow on my colors and
for most of the house types it shows only 10. However, some of the
house types show 11. If I set the show to say 5, all only show 5.
 

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

Top