|
How do I seperate data from a pivot into seperate worksheets?
I have a file that lists out sales. Each sale has a tax classification. If I
create a pivot table grouped by tax classifications, is there a way I can click on the pivot table and new worksheets will appear seperating each tax classification i.e. wholesale sales on one worksheet, retail sales on another? |
Put the Tax Classification field into the Page area of the pivot table
Select a cell in the pivot table On the Pivot toolbar, choose PivotTableShow Pages Shannon wrote: I have a file that lists out sales. Each sale has a tax classification. If I create a pivot table grouped by tax classifications, is there a way I can click on the pivot table and new worksheets will appear seperating each tax classification i.e. wholesale sales on one worksheet, retail sales on another? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
If I can't select Show Pages what should I do?
"Debra Dalgleish" wrote: Put the Tax Classification field into the Page area of the pivot table Select a cell in the pivot table On the Pivot toolbar, choose PivotTableShow Pages Shannon wrote: I have a file that lists out sales. Each sale has a tax classification. If I create a pivot table grouped by tax classifications, is there a way I can click on the pivot table and new worksheets will appear seperating each tax classification i.e. wholesale sales on one worksheet, retail sales on another? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
If your pivot table is based on an OLAP source, the option won't be
available. Could that be the problem? Shannon wrote: If I can't select Show Pages what should I do? "Debra Dalgleish" wrote: Put the Tax Classification field into the Page area of the pivot table Select a cell in the pivot table On the Pivot toolbar, choose PivotTableShow Pages Shannon wrote: I have a file that lists out sales. Each sale has a tax classification. If I create a pivot table grouped by tax classifications, is there a way I can click on the pivot table and new worksheets will appear seperating each tax classification i.e. wholesale sales on one worksheet, retail sales on another? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
I received the data in an excel file. I thing it might be a formatting error
in the tax classification column; it is currently set as text. "Debra Dalgleish" wrote: If your pivot table is based on an OLAP source, the option won't be available. Could that be the problem? Shannon wrote: If I can't select Show Pages what should I do? "Debra Dalgleish" wrote: Put the Tax Classification field into the Page area of the pivot table Select a cell in the pivot table On the Pivot toolbar, choose PivotTableShow Pages Shannon wrote: I have a file that lists out sales. Each sale has a tax classification. If I create a pivot table grouped by tax classifications, is there a way I can click on the pivot table and new worksheets will appear seperating each tax classification i.e. wholesale sales on one worksheet, retail sales on another? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Is the Tax Classification field in the Page area?
Shannon wrote: I received the data in an excel file. I thing it might be a formatting error in the tax classification column; it is currently set as text. "Debra Dalgleish" wrote: If your pivot table is based on an OLAP source, the option won't be available. Could that be the problem? Shannon wrote: If I can't select Show Pages what should I do? "Debra Dalgleish" wrote: Put the Tax Classification field into the Page area of the pivot table Select a cell in the pivot table On the Pivot toolbar, choose PivotTableShow Pages Shannon wrote: I have a file that lists out sales. Each sale has a tax classification. If I create a pivot table grouped by tax classifications, is there a way I can click on the pivot table and new worksheets will appear seperating each tax classification i.e. wholesale sales on one worksheet, retail sales on another? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| All times are GMT +1. The time now is 07:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com