Select first value (regardless of the value) from pivot table filter.

**kaylac** · 06-25-2018, 08:24 PM

Hello,

I am working with School data and each school can have a range of year levels (e.g primary = 3, 4, 5, secondary = 7, 8,9 or combined (3-9).

I'm using VBA to generate multiple reports for these schools but was hoping I could add some additional code to be applied to some of my pivot table filter/slicers.

Is there a way I can code the macro to always select the first Pivot Table item of a set Pivot Table field?

I've only been able to solve this in a very clunky way and it doesn't cover all the combinations of schools I have neatly.

An example of what I have now

HTML Code:

**kaylac** · 06-25-2018, 09:03 PM

Found the answer elsewhere

For reference C is how many values from the bottom you want to make visible.

HTML Code:

Select first value (regardless of the value) from pivot table filter.

LinkBack

Thread Tools

Rate This Thread

Display

Select first value (regardless of the value) from pivot table filter.

Re: Select first value (regardless of the value) from pivot table filter.

Thread Information

Users Browsing this Thread

Similar Threads

How to select all options in pivot table filter greater than a specific value

[SOLVED] Select Automatic Report Filter in Pivot where Filter exist in Data table else select Blank

Using VBA to select multiple values in a pivot table report filter based on a cell value

Select Multiple Dates In Report Filter Pivot Table But Dates Are Not Static

Select (ALL) in a pivot table filter

removing "Select All" and limiting filter choices in a Pivot table

Select and unselect items in a filter in pivot table

Bookmarks

Bookmarks

Posting Permissions