Hello,
I would like to create (as painlessly as possible!) individual reports for our (10)sales reps using a pivot table. I don't want to share our total sales with all reps yet I'd like them to still have a functioning pivot table.
What is the best way to generate the multiple reports for each rep?

New to pivot tables,
KIAT91