Pivot table - allow only one item from report filter.

tweek

Board Regular
Joined
Jun 16, 2006
Messages
104
Hi, I have a pivot table with months in rows and years in columns (not really relavent I think)

This table has a few report filter, one of them being names of persons, there are about 10 names. John , jane , tom ,.. ans ome others.

Is it possible to to create another from this one where John for example can view his "stats" and no other stats? Or is it possible to set the report filter to John and lock it?

thank you.
Einar
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Watch MrExcel Video

Forum statistics

Threads
1,109,451
Messages
5,528,829
Members
409,839
Latest member
akashsadhu
Top