How to delete heading row in pivot output

[arun198322654]

Hi

i want to delete one row out to two row displayed in this pivot out put. pls check the file for more clarity.

Thanks in advance

 

[Nebu]

Hi:

In pivot options display tab uncheck Display field captions and filter drop downs.

Thanks

 

[Deepak]

What nebu said...

 

[jayalaxmi]

hey in 2013 it is giving a bit different option??

 

[Deepak]

2013 PT..

 

[prasaddn]

@Deepak and @Nebu,

The suggestion would make the PT not to show Field Headers, i.e. Category for row and drop down of columns.

I hope thats what OP wanted.

@OP,

If you are looking only to remove the column heading dropdown and to retain Category label then.. Just hide the entire row.

Regards,
Prasad DN