Pivot Table - Simultaneous Drill-Down

V

Valente

In a Excel Pivot Table, when we double-click a cell in the Data area,
a new sheet is created with the details.

What I want to do (I already did it in the past), is when I click a
cell in the Row area, several sheets are created (one per value).

I have already had this feature in Excel in the past (I think it was
an add-on), but I don't remember how to do it again.

Thxs,,

Pedro Valente
 
R

Roger Govier

I think you mean from the Page field, not the Row field.
From the PT Toolbar>dropdown>Show Pages
 

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

Pivot Table - Simultaneous Drill-Down 0
Embed the same Excel multiple times 0
SUM & OFFSET & PIVOT TABLE?? 0
Pivot table drill down sort 0
Pivot Table drill down and 256 character limit 4
Parent of item in Pivot table 1
pivot table loosing decimals (vba) 1
Excel 2007 pivot table using analysis services cube as data source 0

Top