Simple toggle to select how to view data in different ways

You have a couple of options here. Both of which can produce the same result and have the same basic steps. Either way you go you'll have to filter the data to achieve the same result.

For View 1. you don't need any filters, you just need to build your report.

For View 2. drop field x into the filter panel for filters on this page and set it equal to 1

For View 3. filter the page by field y using the TopN feature. TopN would need to equal 1 so it can pick up only the highest value.

Now for the toggle. You can create bookmarks and buttons to toggle between each view. However, I personally don't like working with bookmarks. I always end up messing up the bookmarks when I update them. Nothing against bookmarks, I just try not to use them.

What I would do is create view #1 and duplicate the tab 2 more times. Apply the filters for views 1 and 2 to the other two pages, and use page nagivation between the three. You can hide the additional tabs if you want a cleaner look.