The Slicer worksheet is the most effective tool available to do ad-hoc queries without designing your own workbook.
There are four user selectable fields available to do a drilldown hierarchy, and over 30 measure fields to summarize.
There are over 10 filter fields available
This results in over one million ways to query the data.
As noted in the Hot & Cold views, the four column selections in the Slicer view determine the hierarchy order in the Hot & Cold views.