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.
![](../__attachments/1818132556/image-20221028-214745.png?inst-v=a33ad75e-8fc6-41aa-a53e-3a49a14fd4b2)
Four user chosen fields to group and drilldown
![](../__attachments/1818132556/image-20221028-215550.png?inst-v=a33ad75e-8fc6-41aa-a53e-3a49a14fd4b2)
Over 30 measure fields to report on
There are over 10 filter fields available
![](../__attachments/1818132556/image-20221028-220251.png?inst-v=a33ad75e-8fc6-41aa-a53e-3a49a14fd4b2)
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.