Sometimes it’s too hard to include everything that a reader might want to examine for decision support. One way to present more information concisely is to add some interactive features, allowing the reader to dice, slice and customize what is being reported. Here are three tools that can do just that if you use pivot tables and pivot charts in building dashboards.
Slicers are a way to filter your pivot table report by any field. Using multiple Slicers can also provide information as well as filter. Let’s begin with a single Slicer first. Here are the steps:
1. From inside the pivot table, click into the Pivot Table tools Analyze (Options in Office 2010) tab.
2. In the Filter group, click the Insert Slicer button. You can also find the Insert Slicer button on the Insert tab.
3. Select the field you wish to apply to the Slicer.
HINT: If you don’t see your fields, but a list of data connections, close the d...(register to read more)