Displyaing column/row captions in pivit table

Feb 2, 2012 at 11:35 AM

How do we display names column lables or row lables when we have more than one column or row in pivot table.

I see only the caption property RowHeaderCaption and this will work only we have one row. But what if have multiple rows/columns and we want to display all the headers/labels. This is possible when we create excel pivot tables directly using excel.

Do we have any option here? Also, There is nothing ColumnHeaderCaption and it always displays "Column Lables".

Thanking you in anticipation.