Problem with Pivot Table Top 10 filter

When I click on the field header, go to filter, top 10. I have to 4 dropdowns in order. They are Top/Bottom, #of Items, Items/Percent/Sum, and the last one. The last dropdown which I think would contain the field name is blank. Any idea why this occurs. Perhaps I'm trying at the wrong part of the table?

Already read the exact same link trying to find the solution. Figured someone that has used this feature would know what I was talking about.

I have categories that are YTD totals for two different years. I think I manually entered this column heading. But when I click the heading it still gives me the top 10 option.

Sorry for the delay in posting back.. I figured my question was too vague for anyone to want to answer.

Here is an example pivot table. This is the best I could create. There are 4 other tables similiarly arranged. The YTD 2011 is the one I would want to set as the top 10 category. I'm might start a new thread trying to get help now that I have a file. If I find the answer I'll close this one.

Thanks!

@ Jason what actually you want that pivot table to do.

Here you are showing a commodities variance between year 2011 & year 2010.

What do you mean by top 10.

look the attached file

Jason,

In your dummy file click on cell G4 and drag it to B4. From there click on "Sort & Filter"-->"Filter." Once you get the YTD 2011 drop down you can click on it and goto "Number Filters"-->"Top 10."

Hope this helps!

Thanks Marvin. I think your post helped the most. I'm with you on the fact of renaming the column must have created the problem. I will compare the two tables tonight and try to sort out how I can rework mine to get it where I want.

The reason I wanted to go this route is some of the pivot tables are side-by-side with different amounts of rows. I was having to recreate the row sum and hide rows to get them to show up in an orderly fashion if you understand what I'm saying. This is really my first time working with pivot tables so thanks for all the help.

Marvin
I added Sum of Tons to B3 and Column Labels to C3. This solved it showing up in the field list. I can then get the Top 10 Sum of Tons in my filter. However I cannot change the top ten in yours or get mine to work. If you notice I moved your 2011 column first. This allows the top ten you had to work with 2011. Any suggestions from here? Can you manipulate the top 10 in yours and mine?

Wow. I think you answered more than my original question. I guess you saw I was looking to fix my row total columns too. By doing Value As it keeps my Variance and % Changes working on my total row. As with Calculated Items it didn't work. It must been having calculated items that was keeping my original table from working. I took them out and it works fine. I think I am well on the right track. Thanks so much. I just found the contextures website last week. I will definitely be using it more.