- Mar 17, 2009
I am working in excel 07 with a pivot table where the report filter is "sales rep name". I want to be able to get one tab per sales rep, have the tab named after the sales rep and have the tab contain the detail that makes up their full commission amount that is totaled in the main pivot table. I followed the similar instructions in the "Creating multipe worksheests from a Pivot Table Field" thread and it did create one tab per sale rep but each tab contained a new pivot table instead of the details from the main pivot source. Can anyone help? Thanks.