Breadcrumbs

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.

image-20221028-214745.png
Four user chosen fields to group and drilldown
image-20221028-215550.png
Over 30 measure fields to report on

  • There are over 10 filter fields available

image-20221028-220251.png
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.