Two basic questions:

In my pivot table I click on the "Data" box to get a pop-up window of the possible fields I can filter. By default "show all" is checked. If I go through and uncheck some fields, hit "OK", only those fields are displayed. When I click the "Data" box again, only the fields that I filtered to appear, and even when I hit "Show all", I cant seem to get back that full original list. How do I do this?

Also, is there an easy way to add a customized "group" to this list? For example if I have 30 fields, and regularly want to see the first 10, could I add a selection titled "1st10" to automatically grab the first 10? Seems I only have the choice to select all or individual, and cannot make a custom list.

Final question, could I create a filter with additional logic? Such as 'if category starts is "R"'. Looking for something that allows wildcards, similar to custom option with auto-filter in excel.

I am obviously quite new with pivot tables, if someone could answer these questions I appreciate it, would also like a good link to learning specifically about pivot tables.

Thanks