Run code after updating pivot table christiandating info
Those are constants for the Type argument when adding a pivot table filter.
The following code is pasted onto that code module.
In the example shown below, there are 24 months of Order dates in the Row Labels area.
In the Values area, you can see the total sales for the first few order dates.
To filter the pivot table, so it shows only the Top 10 order dates, follow these steps.
The results change, to show only the 5 order dates with the highest sales amounts.
This example is in the download file, on the Top10Filter sheet.