| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table outlining
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
pivot table outlining
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. IC Data wrote: 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. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
| outlining Pivot Tables | Excel Discussion (Misc queries) | |||
| outlining / Grouping | Excel Discussion (Misc queries) | |||
| Outlining function without subtotals | Excel Discussion (Misc queries) | |||
| How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel | |||
Linear Mode
