how to autofilter a pivot table?

Basically , I have created a pivot table in a new worksheet .
But I dont have any idea to create a data filter of the pivot table in vba code ?

I want to filter all data with the value(Count of Last Name) = 1

Based on macro recorder for fitler data:

Please Login or Register  to view this content.

Here's my code for Create Pivot Table:

Please Login or Register  to view this content.

Attachment 407580

This what will happens , after filtering the data to be "1"
Then , I would like to make the "Row Labels" or "Name" to be same
regardless if the name has spacing or capital letters. Just want to make it the same. How do i do this too ?

Please help

I attached the sample workbook in the previous post

Originally Posted by humdingaling

you cant autofilter a pivot table

replace

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

OMG! It can work. Thank You T^T