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 PivotTable>Show 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 PivotTable>Show 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 PivotTable>Show 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 PivotTable>Show 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 PivotTable>Show 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