Using PivotTables with tabular data

These recipes explain how to do fundamental operations with PivotTables against a tabular model. You will create slicers in Excel. You will then see how to sort and filter the data within Excel that is connected to your model.

Using Slice, Sort, and Filter

In this recipe, you will learn how to insert a slicer, filter your data, and sort the data in an Excel PivotTable.

How to do it...

1. Connect to the model as described in the Connecting to Excel from SQL Server Data Tools recipe.

2. On the Analyze menu, click on Insert Slicers to bring up the Insert Slicers window:

   

3. Scroll down and select the LIGHT_CONDITION checkbox and click OK:

   

4. A new Slicer menu is created and added to the worksheet:

   

5. To use the slicer to filter the data, select the Dawn condition:

   

6. To select multiple filters, click on the icon to enable the selection of more than one filter:

   

7. Select Dawn, Daylight, and Dusk to filter for those three conditions:

   

8. To clear the selection, click on the icon to...