Pivot Table Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using a Pivot Table to return top entries only 1
Pivot Table for Dummies 1
Pivot Table Help 1
Calculating bonuses - but not a VLOOKUP or CEILING? 6
Calculating Differences between columns in a Pivot Table 3
Pivot Data Ranges 1
Rank in Pivot Table 3
How do I exclude a detail measure value and only view Grand Total 1

Back
Top