Vba excel macro

I made pivot table using vba with coloumn id ,name n gender but if i have to put id in filter field of pivot table what orientation should i use like i have used row field for age and gender, so what i will use for filtering using ID USING VBA MACRO

Hey!

If we’re using the Preview version (22.7) we have an activity called Filter Pivot Table… There you can play around this…

Regards,
NaNi

HI @Pushpreet_Singh1

You should be able to accomplish this task quickly and easily with a small bit of VBA code:

https://www.pivot-table.com/2013/10/30/remove-pivot-table-filters-with-vba/

Have a look on it

Regards
Gokul