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

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

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