Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot Table Question
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Question | Excel Discussion (Misc queries) | |||
Pivot Table not Updating | Excel Worksheet Functions | |||
pivot table | Excel Discussion (Misc queries) | |||
Jon Peltier - Pivot Table Result for yesterday's "Complex Chart" Question | Charts and Charting in Excel | |||
pivot table question, sum fields? | Excel Worksheet Functions |