Run code after updating pivot table christiandating info

Posted by / 03-May-2018 12:28

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.

run code after updating pivot table-67run code after updating pivot table-86run code after updating pivot table-13

This example is in the download file, on the Top10Filter sheet.