| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table filter fields
I have a fairly simple pivot table with two filter fields. I would like the
filter fields to show the data selection boxes as they do now however, I don't want the field labels to show up. Is there a way to eliminate the labels and center the data fields over the rest of the pivot table data ? thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pivot table filter fields
copy the pivot filltered data to a new sheet, then delete the pivot sheet.
"vw" wrote: I have a fairly simple pivot table with two filter fields. I would like the filter fields to show the data selection boxes as they do now however, I don't want the field labels to show up. Is there a way to eliminate the labels and center the data fields over the rest of the pivot table data ? thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pivot table filter fields
I agree this would solve the problem on a "one time" basis however, I need to
fix this for a standard report the users are accessing and would not want to copy the data to a new sheet each time. Still looking for a solution? "Ranjit kurian" wrote: copy the pivot filltered data to a new sheet, then delete the pivot sheet. "vw" wrote: I have a fairly simple pivot table with two filter fields. I would like the filter fields to show the data selection boxes as they do now however, I don't want the field labels to show up. Is there a way to eliminate the labels and center the data fields over the rest of the pivot table data ? thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem inserting calculated pivot fields into Pivot Table (2007) | Excel Discussion (Misc queries) | |||
| 2003 Pivot Table Filter (items dropped in the Page Fields) | Excel Discussion (Misc queries) | |||
| fields names do not show in excel 2007 pivot table fields list | New Users to Excel | |||
| number of fields in the row fields in pivot table | Excel Discussion (Misc queries) | |||
| How do I set up filter for page fields in pivot table? | Excel Discussion (Misc queries) | |||
Linear Mode
