How to filter by condition in a pivot tab of excel?

Question

It is a movie dataset in a simple pivot table where the row fields are by the years the movies were released and for columns I have used "box office revenue" as value to result in a column with sum of revenues for each year and a column with average of values each year.

I want to filter the pivot table by "box office revenue" in such a way that I am able to see result with movies that earned less than $10,000,000 in revenue.

But I am not able to do that in microsoft excel. Attaching a snapshot of same sheet in excel and google sheet(where the function to filter by condition is available)

1. EXCEL

2. Google sheets