pivot table outlining

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I know what the result looks like, but I'm not sure how to get there. I
want my pivot table users to be able to expand and contract hidden rows. I
want it to have those little 1,2 icons on the left of the table where you can
expand and contract hidden rows so you can choose to only see the totals.
 
Those outlining symbols don't get created with pivottables.

They get created by using Data|Subtotals or Data|Group and Outline.

But there's nothing that says you can't use Data|Group and Outline with a
pivottable.
 

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 tables - adding dates, descriptions 1
display all row fields in pivot table 1
Question on the occupied field of the pivot table in excel spreadsheet 0
Excel 2007 Pivot Table 3
How do I add extra data to a pivot table? 3
Rows disappear in pivot table 1
Pivot Table Refresh 1
Access Sorting and grouping using multiple tables 0

Back
Top