How can I, or is it even possible to remove the access to a filter on the Row Labels on a pivot table, see image for REF.

Or even just hide it from View

enter image description here

My pivot tablse set up only has Row Labels and Values

( Note. Games Won and Win Ratio is outside of the PIVOT )

enter image description here

1 Answer

Try right clicking on your pivot table > Pivot Table Options > Display > then uncheck the "Display field captions and filter drop downs" tick box

That should work.

1

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy