Hi Boris,
No problem, the extra few paragraphs will make it understandable
to few other people later on who may not be familiar with pivot tables
or filter.
"BorisS" <BorisS@discussions.microsoft.com> wrote
> Sorry, I should have been clear that I am actually a relatively advanced
> user. So I wasn't asking how to use filters. Rather, I thought that there
> was some special sort of pivot filter I hadn't heard about. But you brought
> up a simple idea which I never even thought of doing before. Specifically, I
> never thought of simply putting a filter onto a table sheet. I guess the
> fact that you can change so little in a table made me mentally associate
> pivots with static status. But you are right that filtering just changes the
> hiding property, so that'll do just fine.
Bookmarks