Slicer
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.
Four user chosen fields to group and drilldown
Over 30 measure fields to report on
There are over 10 filter fields available
Over 10 filter selection 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.