Pivot Table Question

[RUSH2CROCHET]

I have a rather large pivot table, which displays (2) years of monthly sales
data for 10 different salespeople. I would like to distribute among my
staff, but without allowing the sales staff to view data pertaining to other
salespersons, which is not relative to them. How would I accomplish this?

All assistance appreciated!

TIA,
Sandi

[Debra Dalgleish]

If you don't want salespeople to see other people's data, base their
pivot table on only their sales data. You can use a filter to extract
their data from the source, then base the pivot table on that.

RUSH2CROCHET wrote:
> I have a rather large pivot table, which displays (2) years of monthly sales
> data for 10 different salespeople. I would like to distribute among my
> staff, but without allowing the sales staff to view data pertaining to other
> salespersons, which is not relative to them. How would I accomplish this?
>
> All assistance appreciated!
>
> TIA,
> Sandi


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html