I have no idea how to describe this, because I don't know if I'm talking
about a pivot table, or filter, or something altogether different.

My colleague has been sent a spreadsheet, origin unknown so we can't ask
them, which details all of the sales made by the different teams over the
past twelve months. On the left, there is a drop down menu from which she
can choose the month, or indeed a total for the year, and along the top there
is another dropdown menu from which she can choose which team. she wants to
look at.

It does return information in the same way a pivot table would, but it's
formatted in quite a different way. And it's much easier to view than a
standard pivot table.

I wondered if anyone could recognise what I'm talking about, and indeed how
you can set this up?