![]() The PIVOTTABLE TOOLS - DESIGN commands on the Ribbon provide you with the options to format a PivotTable, including the following − Filter the Timeline to show 5 months data, from November 2015 to March 2016.Insert a Timeline for the field Order Date.Create a PivotTable with Salesperson in ROWS area and Region in COLUMNS area.When you have a Date field in your PivotTable, inserting a Timeline also is an option to produce an aesthetic report. Three Slicers –Order Date, Quarters and Year will get created.Īdjust the sizes of the slicers, adding more columns for the buttons on the slicers.Ĭreate Slicers for Salesperson and Region fields also.Ĭhoose the Slicer Styles so that date fields are grouped to one color and the other two fields get different colors.Īs you can see, you have not only an interactive report, but also an appealing one, that can be understood easily. ![]() SlicersĪnother sophisticated feature that you have in PivotTables is Slicer that can be used to filter the fields visually.Ĭlick Order Date, Quarters and Years in the Insert Slicers dialog box. The worksheet will be named by the value of the field, which is visible on the tab of the worksheet. Select the field Salesperson and click OK.Ī separate worksheet for each of the values of the Salesperson field is created, with the PivotTable filtered to that value. The Show Report Filter Pages dialog box appears.
0 Comments
Leave a Reply. |