Hi Lucas,

Thank you for your support!

I am a bit confuse on your question, would you mind to drop me a mail at chu4276@gmail.com or a message at LinkedIn? I would like to understand more about your question.

For my best guess, you maybe referring to

wb.Sheets("pivot_table").PivotTables("example").DisplayFieldCaptions = False

wb.Sheets("pivot_table").PivotTables("example").DisplayFieldCaptions = True

Which will show or hide the Row/Column Labels Filter, as shown at section under Row Fields / Column Fields in the article.

In my example, there are no Column Labels because the Column in my example only contains the sum of the value in Rows.

Lastly, if its a function available in Excel, you may use Macro to record the steps, then refer to the step info for which Properties or Methods to use.

Feel free to drop me any message if you have any other enquiries😁

Thanks and best regards,

Kah Em