This project has moved. For the latest updates, please go here.

Display the first row field field name in a pivot table

Dec 19, 2013 at 8:26 PM
Edited Dec 19, 2013 at 8:38 PM
I am trying to create pivot tables with EPPlus. I got the formatting the way I want, tabular rows labels.

However, I want to get rid of the drop down filter "Row labels" and replace it with the name of the first field. I know I can set the PivotTable.RowHeaderCaption property, but that will not be updated if the user edits the pivot table after my code generates it. How do I not display the RowHeaderCaption with the filter?

I have made a sample that pulls data from NYC open data. That creates a pivot table illustrating the problem.