Remove rows with blank or zero values in Pivot Table

[farrusete]

Hi,

I have one table with different columns:

Col1, Col2, Col3 -> Values
Selector -> Contains duplicated values which will be used for dropdown in Test sheet
Auto1, Auto2, Auto3 -> Calculated cells to be shown in pivot table at Calculations Sheet

When I select a value from the dropdown at test sheet, that "Auto"&cell value field is added to the pivot table

How could I filter with VBA that pivot table to hide rows with zero values or blank ones?

Thank you in advance

 

[Luke M]

Sure thing, we can add a line to you macro telling it to filter a column on the new data field.

 

[farrusete]

Thank you so much Luke!