VBA Pivot Table Filter
Solved
alexysr
Posted messages
25
Status
Member
-
alexysr Posted messages 25 Status Member -
alexysr Posted messages 25 Status Member -
Hello,
I'm explaining my expectation:
In one of the filters of my pivot table, I have values ranging from negative to positive and empty cells. I only want to keep the positive values and therefore ignore the negative, null, and empty ones.
Here is the part of the code
I thought about clearing all the filters and keeping only the positives, but that doesn't work, need some help please :D
Thank you very much, have a great day!!
Alexysr
I'm explaining my expectation:
In one of the filters of my pivot table, I have values ranging from negative to positive and empty cells. I only want to keep the positive values and therefore ignore the negative, null, and empty ones.
Here is the part of the code
I thought about clearing all the filters and keeping only the positives, but that doesn't work, need some help please :D
ActiveSheet.PivotTables("Tableau croisé dynamique6").PivotFields( _
"Quantité Reçue").ClearAllFilters
With ActiveSheet.PivotTables("Tableau croisé dynamique6").PivotFields( _
"Quantité Reçue")
.PivotItems(">0").Visible = False
End With
Thank you very much, have a great day!!
Alexysr