Filter on pivot table values after pivotupdate event

Hi Guys,

i have pivot table like here:
Screenshot_1.png

and what i want is to add filter on values to exclude values <> 0.
Manually when i am setting this up it is working like a charm without any issues.

I recorded even macro to this via VBA but i am getting error:
Autofilter method of range class failed.

Please Login or Register  to view this content.

Code to this is like above.
The perfect solution would be to take address from target pivot table and use it to filter specific field.

Please help,
Jacek

Have you considered also putting the age in the Report Page filter area, multiple items option, and unticking 0?

Hi,

I didnt think about it.
It will be reaplying after refreshing table?

Best,
Jacek

Thinking about it further, can I ask whether you can have a new extra column in the data? A simple flag of a formula of =C2>0 type of thing ... giving either TRUE or FALSE, and use that in the Report Page filter ... it will be correct on refresh then.

Hmm it is not working after refreshing.

I have to still do this manually...

Jacek

Ok but this can work using something like:

Please Login or Register  to view this content.

If i will create filter field in my pivot table.
How to add criteria to make this "<>0"?

Please help,
Jacek

Originally Posted by jaryszek

Hmm it is not working after refreshing.

I have to still do this manually...

Jacek

What isn't? My suggestion of having an extra column, then putting it in the Report Page filter works fine ... see attached:

Ok it is working.

Thank you. But with my specific client i can not add additional column.

Do you know maybe how to create code for filtering in VBA?

Jacek

Ah, OK. Well, can you see if this does what you want:

Please Login or Register  to view this content.

Thank you!!!

Jacek